/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

10 votes372 views3 answers
Join multiple tables sql
SQL
0 vote318 views1 answer
Plsql trigger insert update
SQL
0 vote335 views1 answer
Including parameters in OPENQUERY
SQL
0 vote361 views1 answer
Oracle current timestamp
SQL
0 vote348 views1 answer
Postgres jsonb array push new element
SQL
4 votes418 views1 answer
Mysql store ip address
SQL
8 votes351 views1 answer
Oracle tablespace datafile max size
SQL
1 vote354 views1 answer
Psql lst trigger
SQL
34 votes346 views6 answers
Sql change data type
SQL
1 vote358 views2 answers
Mssql show database size
SQL