Join the conversation

; add nahi kia
Reply

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

timestap 01:49 pe error semicolon (;) missing ki hai
Reply

1:49 ; ye galti h
Reply