/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

3 votes240 views1 answer
Oracle transaction commit rollback example
SQL
1 vote231 views1 answer
Postgresql create table with timestamp
SQL
38 votes231 views6 answers
Alter table mysql
SQL
4 votes294 views2 answers
Sql display today's date
SQL
0 vote217 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote175 views1 answer
Ms sql - add one hour to time
SQL
-1 vote226 views3 answers
Create temp table in sql
SQL
0 vote228 views2 answers
How to login to mysql as normal user in ubuntu
SQL
-1 vote237 views3 answers
Compute age mysql
SQL
0 vote229 views1 answer
Linked server delete openquery
SQL