• Thanks again for your really helpful reply.

    This gives me below output :

    rollnonameclassSortOrder

    1RobertIT1

    1DavidScience2

    1MichelCommerce4

    1AlbertGeography5

    1RichardHistory6

    2HussainIT1

    2JonathanScience2

    2JohnArts3

    3PoloIT1

    4JosephHistory6

    Kindly tell me how do i get required i.e. row number 1,6,9 and 10 please. This grouping is making me crazy.

    Thanks and Regards

    Girish Sharma