NeoMarine Posted April 29, 2008 Share Posted April 29, 2008 Hi, I have a table with values in it like this: ID = 1 -- Word = hello ID = 2 -- Word = you ID = 3 -- Word = smell ID = 4 -- Word = you ID = 5 -- Word = smell ID = 6 -- Word = you I want to get the top 3 values from the above table, so that it orders like this: first value returned = you second value returned = smell third value returned = hello Why? --because 3 entries of "you" was found, 2 entries of "smell" was found and 1 entry of "hello" was found I will be using a Group By in combination, but it doesn't tell me the "count" of how many duplicates or fields where grouped together... Please help - thanks!! Quote Link to comment Share on other sites More sharing options...
NeoMarine Posted April 29, 2008 Author Share Posted April 29, 2008 edit: I would also like to be able to do something like "select count([total entries of word found]) as CountOfWord From bla bla..." Quote Link to comment Share on other sites More sharing options...
fenway Posted April 29, 2008 Share Posted April 29, 2008 Well, you can COUNT() and GROUP BY word... the count is the numbers of "dupes" in your case. Quote Link to comment Share on other sites More sharing options...
NeoMarine Posted April 29, 2008 Author Share Posted April 29, 2008 THANK YOU! :D Ahh thats the trick right there Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.