Count the occurrences of DISTINCT values

October 4, 2022 by Tarik

SELECT name,COUNT(*) as count 
FROM tablename 
GROUP BY name 
ORDER BY count DESC;