rogerpons
1/29/2020 - 10:16 AM

sql count distinct values

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