table is like this, say it represents various types of events in a log file
<type> <date>
I want to select the top 5 most common types
select type,count(type) as c from log order by c desc limit 5
this works fine, but I only want the type column so I can use this is a where in
subquery. How do I do that? I cant work out how to supress the count colum
Aucun commentaire:
Enregistrer un commentaire