Getting Top 5 from table of same category
-
Hi Friends, Let me Show u my table first and explain the problem later CategoryID CategoryName 1 MSDN 2 Google 3 Project 4 Code 5 Google 6 Project 7 MSDN 8 Google 9 Google 10 MSDN 11 Project 12 Project Now i need the top 2 categorynames from categorynames. I need the result as below CategoryID CategoryName 1 MSDN 7 MSDN 2 Google 5 Google 3 Project 6 Project 4 Code Please some one help me in getting this Query............ Thanks in Advance :)
-
Hi Friends, Let me Show u my table first and explain the problem later CategoryID CategoryName 1 MSDN 2 Google 3 Project 4 Code 5 Google 6 Project 7 MSDN 8 Google 9 Google 10 MSDN 11 Project 12 Project Now i need the top 2 categorynames from categorynames. I need the result as below CategoryID CategoryName 1 MSDN 7 MSDN 2 Google 5 Google 3 Project 6 Project 4 Code Please some one help me in getting this Query............ Thanks in Advance :)
Top 2 on what basis? What is the rule to define which way the records are sorted?
-
Top 2 on what basis? What is the rule to define which way the records are sorted?
-
Then the result you have shown does not match the data in the table.