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