SQL HAVING 절

1 개요

SQL HAVING Clause

SQL HAVING 절

• 4명 미만인 팀 조회하기

sql

Copy

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

2 같이 보기

• SQL COUNT()
• SQL GROUP BY

3 참고

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