/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

1 vote162 views1 answer
Copy postgres table from one schema into another
SQL
5 votes188 views1 answer
Mysql where one year ago
SQL
0 vote192 views2 answers
Identity syntax in sql
SQL
0 vote161 views2 answers
Android sqlite tutorial for beginners
SQL
13 votes167 views6 answers
Mysql update from select
SQL
2 votes166 views1 answer
Plsql block
SQL
-2 votes188 views1 answer
Mysql see users and passwords
SQL
0 vote197 views1 answer
Testing sql queries
SQL
4 votes163 views1 answer
Id primary key auto generated
SQL
3 votes173 views5 answers
Mysql get last inserted id
SQL