There is an enter table with id, uid, date fields.
You need to extract 5 uid , which occur most often, from the most common, and, accordingly, another 4, inferior to the first.
How can this be implemented? I myself cannot reach any ideas.
2 answers
Will return the 5 most common uid and number of times they met in the count table
select count(uid) as count, uid from enter group by uid order by count desc limit 5 
Vadim Prokopchuk Vadim Prokopchuk
2.214 one ten 33
- It seems to me - you need to fix it! Instead of
idinselect, you needuid. - Majestio - @Majestio, thanks. Corrected - Vadim Prokopchuk
|
Like this (tried for for MySQL):
SELECT u.uid, COUNT(u.uid) FROM enter AS u GROUP BY u.uid ORDER BY COUNT(u.uid) DESC LIMIT 5 
Majestio Majestio
2,917 one five 32
|