Query

• jagjitsingh

  Ten Centuries

  Points: 1068

  More actions

  October 31, 2017 at 11:58 pm

  #341008

  Hi
    I have data like below . I want Group By Prod Group having Value = 5 . Under that Group i want to display all Item Nos till next Prod Group value = 5  and so on
  In below Case
         1000 Main Group , under that i want to display data of Items 1001 , 1002, 1003, 1004 till 1049. 
         1050 Main Group , under that Items 1051 , 1052 till 1099 to be displayed.
       Item Code            Prod Group
       1000                    5
           1001                2
           1002                2
           1003                2
           1004                2
        1050                   5
             1051              2
             1052              2
        1100                   5
    and son on
  Thanks

• Eirikur Eiriksson

  SSC Guru

  Points: 182946

  More actions

  November 1, 2017 at 12:24 am

  #1966114

  jagjitsingh - Tuesday, October 31, 2017 11:58 PM

  Hi
    I have data like below . I want Group By Prod Group having Value = 5 . Under that Group i want to display all Item Nos till next Prod Group value = 5  and so on
  In below Case
         1000 Main Group , under that i want to display data of Items 1001 , 1002, 1003, 1004 till 1049. 
         1050 Main Group , under that Items 1051 , 1052 till 1099 to be displayed.
       Item Code            Prod Group
       1000                    5
           1001                2
           1002                2
           1003                2
           1004                2
        1050                   5
             1051              2
             1052              2
        1100                   5
    and son on
  Thanks

  Can you please post the DDL (create table) script, sample data as an insert statement and the expected results.
  

  This problem is trivial but most of us do not have time for creating example sets or guessing the meanings of wage ambiguous questions.