Count Unique Values of one Column

SELECT col_name, COUNT(*) AS frequency 
FROM tbl_name
GROUP by col_name
ORDER BY frequency DESC;
Ebook Download
View all
Learn
View all