Answers for "write sql query to find highest salary of each department"

SQL
0

FIND OUT THE NAME HIGHEST SALARY SQL

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT MAX(SALARY) FROM EMPLOYEES);
Posted by: Guest on November-27-2020
1

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
0

write sql query to find the second highest salary of employee

SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);
Posted by: Guest on November-07-2021

Code answers related to "write sql query to find highest salary of each department"

Code answers related to "SQL"

Browse Popular Code Answers by Language