Results 1 to 2 of 2
Thread: Select the most frequent value
Aug 6, 2007, 02:16 #1
Select the most frequent value
I have a table like this:
Where you see the numbers 1 and 2 in the table is the "user_id", and i want him to tell me what's the user id that has more rows.
In the picture you see that number one appears more times than number two.
So sql would assume that the user number one has more rows than number two, so in a TOP 5 list of who has more rows, number one would be in first place!
How can i tell sql to see which number/string/value appears/exists with more frequency?
Aug 6, 2007, 02:27 #2
- Join Date
- Oct 2006
- Kathmandu, Nepal
- 0 Post(s)
- 0 Thread(s)