/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 vote151 views1 answer
Sql query inline if
SQL
0 vote134 views1 answer
Sql select with apostrohpe
SQL
0 vote159 views1 answer
Sql get table last modified time
SQL
2 votes138 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote137 views1 answer
Get number of tables in database sql
SQL
6 votes141 views2 answers
Oracle trigger
SQL
-1 vote151 views1 answer
How to Activate the database
SQL
10 votes138 views3 answers
Sql select between two dates
SQL
0 vote129 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote128 views1 answer
Select other columns with distinct
SQL