MYSQL: select duplicate fields from table

SELECT `$col`, count(`$col`) as `num`
FROM `$table`
GROUP BY `$col`
ORDER BY `num` desc