Skip to main content
nikos101
nikos101
Inspiring
March 31, 2009
Question

I would like to return the top 50 most popular words

  • March 31, 2009
  • 11 replies
  • 1652 views
HI, I have a text column in mssql, I would like to return the top 50 most popular words and their count(for all rows) excluding the words

i
a
it
the

Any clue how to do this?
This topic has been closed for replies.

11 replies

Show previous replies
N
Newsgroup_User
Inspiring
April 1, 2009
nikos101 wrote:
>
> Any clue how to do this?

You are probably going to use 'TOP 50' and NOT IN ('list','of','words')
in your SQL. But no, I really don't have much of a clue since I have no
idea what your database schema looks like.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices