/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 vote171 views1 answer
How to format tables in sqlplus
SQL
1 vote178 views1 answer
Regular expression in sql server
SQL
9 votes246 views3 answers
Postgres make sql dump
SQL
0 vote183 views2 answers
Sqlite
SQL
0 vote195 views1 answer
Mysql reset wp_options
SQL
0 vote186 views1 answer
Dbms_output sql developer
SQL
7 votes186 views2 answers
Html to react converter
SQL
8 votes222 views1 answer
Ltrim sql
SQL
0 vote173 views1 answer
Mysql group rows with same value
SQL
2 votes224 views2 answers
How to check data type in sql server
SQL