top 2 most frequent values in column

[Vivid Lust]

I'm trying to get the top 2 most frequent values in a specific column in a db, so heres an example

 

 

column_name

7

8

8

4

5

7

7

8

8

 

 

RESULT:

8,7

 

 

Is this possible? And if so how can it be achieved?

 

Thanks lots!!

 

Jake

[PFMaBiSmAd]

SELECT column_name FROM your_table GROUP BY column_name ORDER BY COUNT(*) DESC LIMIT 2

[Pikachu2000]

This should get you the results you're after.

 

SELECT COUNT(field) FROM table GROUP BY field ORDER BY COUNT(field) DESC LIMIT 2

[ManiacDan]

PFMaBiSmAd's solution gives you the field name, Pikachu's solution gives you the two highest frequencies.  The former is probably what you're after.

 

If you want the value AND the frequency, just combine the two:

 

SELECT field, COUNT(field) as frequency FROM table GROUP BY field ORDER BY COUNT(field) DESC LIMIT 2

-Dan