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 earning the highest salary.

  1. SELECT * FROM EMP WHERE SAL>1

  2. SELECT * FROM EMP WHERE SAL>0

  3. SELECT * FROM EMP WHERE SAL IN(SELECT COUNT(DISTINCT SAL) FROM EMP )

  4. SELECT * FROM EMP E WHERE 0=(SELECT COUNT( SAL) FROM EMP WHERE SAL>E.SAL)

  5. SELECT * FROM EMP E WHERE 0=(SELECT COUNT(DISTINCT SAL) FROM EMP WHERE SAL>E.SAL)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

This is the correct syntax for the desired result.

Keep practicing — related questions