/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

0 vote180 views1 answer
Openquery insert into linked server
SQL
0 vote194 views1 answer
Mysql limit order by
SQL
0 vote179 views1 answer
Less mysql display
SQL
3 votes194 views2 answers
Search text in all sql server stored procedure
SQL
1 vote190 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote175 views1 answer
Mysql command prompt date insert format
SQL
1 vote193 views3 answers
Date_add mysql
SQL
0 vote200 views1 answer
Select * from mysql.proc
SQL
0 vote188 views2 answers
Advantages of stored procedures sql
SQL
1 vote193 views1 answer
How to select the nth row in a SQL database table?
SQL