/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

44 votes446 views4 answers
Mysql alter table add column first
SQL
0 vote334 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote390 views3 answers
Mysql CAST(amount as float)
SQL
16 votes375 views5 answers
Select last row in sql
SQL
1 vote344 views1 answer
Mysql month name extract
SQL
7 votes338 views3 answers
Postgre describe table
SQL
0 vote334 views1 answer
Low level operator in dbms
SQL
1 vote421 views2 answers
Coderbyte sql solutions
SQL
6 votes320 views1 answer
Oracle trigger after connect
SQL
0 vote339 views1 answer
Sql not exists
SQL