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 - 2001-03-05 : 00:29:33
|
Brad writes "I have a very simple table, basically a unique id and a field that stores keywords. I want to return the top 10 keyword and how many times the each keyword occured.
My table
id
keyword
date
Results I want would be like
keyword
number of occurences
Ordered by popularity" |
|
|
|
|
|
return duplicate field values, how many and whats the value