Can you please help me get sql query for below output from the input provided : TABLE: No of classes Student Science A Commerce A Science B Science C Commerce C Commerce C Science B Science A Science G Commerce D Commerce D OUTPUT: No of classes Student Count Science A 2 Commerce A 1 Science B 2 Science C 1 Commerce C 2 Commerce D 2 Science G 1 I will appreciate the help.
chinday · Feb 12, 2019 6:41 PM · 17,512 views
You might want to try something like this: select number of classes, student, count(*) as Count From tablename group by number of classes, student Good luck!
nepalinaike · Feb 12, 2019 6:50 PM
SELECT NO OF CLASSES,STUDENT,COUNT(*) AS COUNT FROM TABLE GROUP BY NO OF CLASSES,STUDENT ORDER BY STUDENT ASC;
Lee_St · Feb 12, 2019 9:54 PM
SELECT [No of classes], Student, COUNT(*) AS Count FROM TABLE GROUP BY [No of classes], Student ORDER BY Student ASC, [No of classes] DESC;
STUPIDA · Feb 13, 2019 1:42 AM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion