select keywords on row
Posted on 2011-09-14
hi, this is difficult for me, but i don't think is for u guys. here we go.
i want an sql query or storeprocedure that select 15 words that repeat more on some of the rows.
1 we will eat cheese today
2 you guys are great developers
3 cheese is the best food ever
4 computer is great for developers
5 food like cheese is never to eat alone
ok, so the query should give me something like this: " cheese, developers, is, food, great "
since the text is kind bigger i will only have 10 words most repeated between the range selected.