← Back to Kurakani

SQL query Help!

Original Post

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
3 Replies
nepalinaike Feb 12, 2019 6:50 PM
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!
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;
STUPIDA Feb 13, 2019 1:42 AM
SELECT [No of classes], Student, COUNT(*) AS Count FROM TABLE GROUP BY [No of classes], Student ORDER BY Student ASC, [No of classes] DESC;
Login to join the conversation.

You might be interested in...

Latest Kurakani View all
Page 1 of 30
Recent Classifieds View all
Page 1 of 32
Upcoming Events View all
Page 1 of 2
Service Providers View all
Page 1 of 23
Ask Sajha AI Assistant