/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

19 votes337 views6 answers
What is mySQL
SQL
4 votes328 views4 answers
Sqlite describe table
SQL
0 vote305 views2 answers
Avg() sql
SQL
1 vote361 views1 answer
Insert many to many sql
SQL
3 votes334 views3 answers
Sql last week
SQL
15 votes345 views2 answers
Select where duplicate mysql
SQL
0 vote342 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote275 views1 answer
Postgresql add leading zeros
SQL
-1 vote361 views5 answers
Not in sql
SQL
12 votes339 views2 answers
Find duplicates mysql column
SQL