Hi
I have 1 query which returns record order by ID like this. Now i want that in addition to the below Query i want another query to group by Name thru Stored Procedure . Since A is at top first record with Name 'A' top 3 records are displayed . Then with name C , Then B & so on
ID Name
1000 A
990 C
980 A
970 A
960 B
950 C
930 A
Final Data Should be like this
ID Name
1000 A
980 A
970 A
990 C
950 C
960 B