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!! Link to comment https://forums.phpfreaks.com/topic/103378-solved-order-by-most-duplicates/ 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..." Link to comment https://forums.phpfreaks.com/topic/103378-solved-order-by-most-duplicates/#findComment-529396 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. Link to comment https://forums.phpfreaks.com/topic/103378-solved-order-by-most-duplicates/#findComment-529492 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 Link to comment https://forums.phpfreaks.com/topic/103378-solved-order-by-most-duplicates/#findComment-529556 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.