mercredi 2 décembre 2015

selecting a column sorted by count but without the count

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