having ์ ์๋ธ์ฟผ๋ฆฌ
SELECT
months * salary AS earnings,
COUNT(*)
FROM Employee
GROUP BY earnings
HAVING earnings = (SELECT MAX(months * salary) FROM Employee)
SQL
๋ณต์ฌ
where ์ ์๋ธ์ฟผ๋ฆฌ
SELECT
months * salary AS earnings,
COUNT(*)
FROM Employee
WHERE months * salary = (SELECT MAX(months * salary) FROM Employee)
GROUP BY earnings
;
SQL
๋ณต์ฌ