ansaurus

Question

Answer 1

+2 A:

select published, count(*) nbr
from table1
group by published
order by nbr desc
limit 1

You don't really need the count, but if you wanted confirmation that the choice seemed reasonable, you could use it. Also, you didn't specifically say whether you wanted ONLY the one, or wanted to see which was the most frequent, along with frequencies of the other records. Take off the limit 1 if you want to see all records.

MJB 2010-06-23 12:53:46

Im after about 5 i would say its to allow the user to stop typing the publised everytime.

Dean 2010-06-23 13:04:59

is it possible to add a where condition as publication has 3 different types which is a another column in the table called type?

Dean 2010-06-23 13:34:05

Sure -- give some more info, either here or in new question. But based on what I know, I would go with "select published, count(*) nbr from table1 where type in ('type1', 'type2') group by published order by nbr desc limit 1"

MJB 2010-06-23 14:07:54

ansaurus

tags:

views:

answers:

Select most frequent from column in

related questions