/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 vote338 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote344 views1 answer
Using distinct and count together in sql
SQL
1 vote343 views1 answer
How to select the nth row in a SQL database table?
SQL
1 vote296 views1 answer
Mssql string length
SQL
0 vote333 views1 answer
A network or instance-specific error sql server
SQL
1 vote335 views1 answer
Import sql file mysql commadn line
SQL
2 votes358 views2 answers
Get all tables using like
SQL
2 votes313 views1 answer
Mysql sysdate
SQL
1 vote337 views1 answer
How to update date add hours in postgresql
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL