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
Joaquin Diaz -
jawwad22 -
Nico Prat -
Max -
Top comments (0)