SQL HAVING 절

개요

SQL HAVING Clause

SQL HAVING 절

• 4명 미만인 팀 조회하기

SELECT team, COUNT(id)
FROM employees
GROUP BY team
HAVING COUNT(id) < 4;

같이 보기

• SQL COUNT()
• SQL GROUP BY

참고

• https://www.w3schools.com/sql/sql_having.asp