Solution for "how to get second maximum salary in sql"

SELECT E.Employers_name, E.dep_number, E.salary FROM Employers E WHERE 1 = (SELECT COUNT(DISTINCT salary) FROM Employers B WHERE B.salary > E.salary AND E.dep_number = B.dep_number) group by E.dep_number

how to get second highest salary in each department in sql

Similar codes for "how to get second maximum salary in sql"


Latest 'SQL' questions

Added before "how to get second maximum salary in sql"