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
Anthony Simmon -
Raju Nekadi -
Remagine AI -
Jimmy Guerrero -
Top comments (0)