query to get the total number of students in each class

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 829
SELECT ClassName,COUNT(*) AS NO_STUDENTS 
FROM STUDENT
GROUP BY ClassName

Comments or Responses

Login to post response