Answers for "Write an SQL query to find out the second highest salary from an Employees table."

how to get second highest salary in each department 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

Posted by: Guest on January-28-2021

Code answers related to "Write an SQL query to find out the second highest salary from an Employees table."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "Write an SQL query to find out the second highest salary from an Employees table."

Code answers related to "Write an SQL query to find out the second highest salary from an Employees table."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "Write an SQL query to find out the second highest salary from an Employees table."

Code answers related to "Write an SQL query to find out the second highest salary from an Employees table."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us