You are viewing a single comment's thread. Return to all comments →
The last one ("To use WHERE:") will not work without a GROUP BY statement Correct code:
SELECT (salary*months), COUNT(*) FROM Employee WHERE (salary*months) = (SELECT MAX(salary*months) FROM Employee) GROUP BY (salary*months)
Seems like cookies are disabled on this browser, please enable them to open this website
Top Earners
You are viewing a single comment's thread. Return to all comments →
The last one ("To use WHERE:") will not work without a GROUP BY statement Correct code: