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
Wallace Maxters -
Krinskumar Vaghasia -
Nnamdi Okpala -
Danial Ranjha -
Top comments (0)