SELECT *
FROM employee_info e1
WHERE N-1 =
(
SELECT COUNT(DISTINCT salary)
FROM employee_info e2
WHERE e1.salary < e2.salary
)
For further actions, you may consider blocking this person and/or reporting abuse
SELECT *
FROM employee_info e1
WHERE N-1 =
(
SELECT COUNT(DISTINCT salary)
FROM employee_info e2
WHERE e1.salary < e2.salary
)
For further actions, you may consider blocking this person and/or reporting abuse
U G Murthy -
Excalibra -
Emmanuel Cobham -
Sudhanshu Gaikwad -
Top comments (0)