MySQL order by count

SELECT val,COUNT(*) as count FROM temptable GROUP BY val ORDER BY count DESC;

SELECT val,COUNT(*) as count FROM temptable GROUP BY val ORDER BY count DESC;