Thread: Listing words with no of occurances in sql server
View Single Post
  #4 (permalink)  
Old 12-18-06, 08:58
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,083
Code:
select wordcolumn
     , count(*) as occurrences
  from daTable
group
    by wordcolumn
order
    by occurrences desc
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote