/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 vote174 views1 answer
Create column that already exists mysql
SQL
0 vote175 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote126 views2 answers
Last working day in week date function in sql
SQL
1 vote160 views3 answers
Getdate function in postgresql
SQL
0 vote180 views1 answer
Can sqldatareader be null
SQL
1 vote165 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote266 views1 answer
Oracle sql all days except weekends
SQL
0 vote161 views1 answer
Mysql autoincrement valor inicial
SQL
8 votes189 views1 answer
Oracle current date plus 1 month
SQL
7 votes173 views2 answers
3rd height salary sql
SQL