/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 vote163 views1 answer
Metada in sql
SQL
6 votes200 views3 answers
Create database mysql utf8
SQL
17 votes176 views4 answers
Show tables sql server
SQL
0 vote188 views1 answer
Mysql make date from 2 column
SQL
1 vote176 views1 answer
Influxdb export to csv
SQL
1 vote214 views1 answer
Join to find results not in another table
SQL
0 vote183 views1 answer
Move table to a different schema
SQL
0 vote222 views1 answer
Creating sqeuence in oracle database
SQL
0 vote130 views1 answer
Oracle sql developer script output limit
SQL
8 votes202 views1 answer
Alter tablespace add datafile autoextend
SQL