Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-28 : 09:55:46
|
Dror writes "I have a large table which consists of names of students. Some of the names appear numerous times. I need to query the table to give me the top 10 rows ordered by the number of times a specific name appears. So if I have the name 'John' which appears 15 times in my table (with 'john' appearing the most times),the first row will give my 'john', '15'. I need to query the table by going from the top 10 to the last 10, each time using a different query (if possible)
I am using SQL Server 7.0 IIS 4
Thanks for you help
Dror" |
|
|
|
|
|
Retrieving rows based on count of each item in a table