/SQL/Write sql query to find the second highest salary of employee

Write sql query to find the second highest salary of employee

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

Sql find second highest salary employee

/* sql 2nd highest salary employee */
select sal, ename
from emp
where sal =
    (
        select max(sal) from emp where sal <
            (select max(sal) from emp)
    )
----------------------------------------------- option 2
select *
from 
(
    select ename, sal, dense_rank() over(order by sal desc) rank
    from emp
)
where rank =2;

Write sql query to find the second highest salary of employee

SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);

Source: java67.com

Similar codes

7 votes246 views1 answer
Grant schema permissions postgres
SQL
0 vote250 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote236 views1 answer
Get number of table colums in sql query
SQL
1 vote235 views1 answer
Stored procedure return value
SQL
1 vote292 views1 answer
Update substring in mysql
SQL
2 votes267 views1 answer
Mysql virtual column
SQL
3 votes282 views1 answer
Oracle sql commit example
SQL
0 vote250 views1 answer
Oracle drop default value
SQL
5 votes254 views1 answer
Mysql change primary key
SQL
6 votes286 views3 answers
How to delete table sqlite
SQL