Multiple choice technology databases

Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve

  1. 3500,5000,2850

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The nested query counts how many employees have salary LESS than the current employee (E1.SAL > E2.SAL). The condition 3 > count(*) means we want salaries where at most 2 other salaries are lower. For 3500: only 2850 is lower (count=1). For 5000: 3500 and 2850 are lower (count=2). For 2850: none are lower (count=0). For 5750: three are lower (count=3, fails condition).

Keep practicing — related questions