Multiple choice

Consider the following database table

Table Name- EM ||||| |---|---|---|---| |empid|deptno|Salary|city| |011|501|20000|Mumbai| |012|502|15000|Gurgaun| |013|503|24000|Delhi| |014|504|30000|Lucknow|

Find the details of employees who are earning the highest salary in each department.

  1. SELECT MAX(SAL) FROM EMP GROUP BY DEPTNO

  2. SELECT * FROM EMP WHERE SAL>1 GROUP BY DEPTNO

  3. SELECT * FROM EMP WHERE SAL IN(SELECT SAL FROM EMP GROUP BY DEPTNO)

  4. SELECT * FROM EMP WHERE SAL IN(SELECT MAX(SAL) FROM EMP GROUP BY DEPTNO)

  5. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is a correct syntax for desired output.

Keep practicing — related questions