Search

Top earner

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
๋ณต์‚ฌ