Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql count having

-- Classes with more than 10 students
SELECT student_class, COUNT(*) FROM students GROUP BY student_class 
	HAVING count(*) > 10;
 
PREVIOUS NEXT
Tagged: #sql #count
ADD COMMENT
Topic
Name
5+6 =