How to get maximum repeat count with sql

Question

Hello cou table name

name type kasu 1 kasu 4 kasu 3 nimal 1 nimal 2

I need this answer as

 name cnt kasu 3

+4

Kasun Shamentha Jun 09 '12 at 15:58

1 answer

Sebas · Accepted Answer · 2012-06-09T16:10:23+0000

 SELECT name, COUNT(name) AS `cnt` FROM cou GROUP BY name ORDER BY `cnt` DESC LIMIT 1

OK, so, sorry, I did not find something more elegant, so I did it stupidly. There is definitely another way to do this, though ...

Demo with your example