Join the conversation
![](https://codanics.com/wp-content/uploads/2024/02/2.jpg)
To show the number of occurrences of unique values in a column of mySQL table
SELECT stuCITY, COUNT(*) as count FROM students GROUP BY stuCITY ORDER BY count DESC;
Reply
![](https://codanics.com/wp-content/uploads/2024/02/2.jpg)
timestap 01:49 pe error semicolon (;) missing ki hai
Reply
1:49 ; ye galti h
Reply