/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 vote290 views1 answer
Does insert into overwrite sql
SQL
0 vote306 views2 answers
Plpgsql
SQL
0 vote308 views1 answer
Postgres dump sql insert
SQL
6 votes278 views2 answers
Mysql first day of month
SQL
2 votes288 views2 answers
Change varchar length mysql
SQL
0 vote280 views1 answer
Mysql table variables
SQL
2 votes291 views1 answer
Laravel sql String
SQL
1 vote302 views2 answers
Oracle list service names
SQL
0 vote256 views1 answer
Como leer datos de mysql esp32
SQL
0 vote293 views1 answer
How to get parent and child record in single query using sql
SQL