/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 vote110 views1 answer
Sql view index
SQL
1 vote122 views1 answer
Events mysql
SQL
0 vote133 views1 answer
Python mysql check if database exists
SQL
6 votes287 views3 answers
Sql select last id
SQL
0 vote120 views1 answer
Jdbc sql connection string
SQL
0 vote130 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote114 views1 answer
What is SQL data store?
SQL
31 votes121 views4 answers
Mysql grant execute
SQL
1 vote131 views1 answer
Oracle sequence last_number
SQL
1 vote139 views2 answers
Oracle leftmost characters
SQL