mysql - SQL - select the most frequency item -
suppose have table below:
id | name ---------- 01 | tony 02 | peter 03 | tony 04 | tony 05 | john .. | .. 99 | david
how can use sql statement frequency of field name(tony)?
something along lines of:
select name table_name group name order count(*) desc limit 1;
Comments
Post a Comment