[MSSQL 문법] HAVING COUNT(*)

데이타베이스/MSSQL

유키공 2017. 12. 12. 13:17

HAVING 문법

SELECT 
	column_name(s)
FROM 
	table_name
WHERE 
	condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);

SQL HAVING 예제

SELECT 
	COUNT(HPNum), car_name
FROM 
	INP_Car_councel
GROUP BY car_name
HAVING COUNT(HPNum) > 5;

SELECT 
	COUNT(HPNum), car_name
FROM 
	INP_Car_councel
GROUP BY car_name
HAVING COUNT(HPNum) > 5
ORDER BY COUNT(HPNum) DESC;