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
Mike Young -
Meursyphus -
Meursyphus -
Rodrigo Manozzo -
Top comments (0)