Count the occurrences of DISTINCT values May 13, 2022 by Tarik SELECT name,COUNT(*) as count FROM tablename GROUP BY name ORDER BY count DESC;