/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 vote287 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote298 views1 answer
How to reset table in sql server
SQL
0 vote325 views1 answer
Select distinct after join
SQL
0 vote296 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote291 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote311 views1 answer
Example database query
SQL
0 vote303 views2 answers
Nosqlbooster query other collection
SQL
0 vote277 views1 answer
Sqlite referential integrity
SQL
23 votes283 views6 answers
Delete all rows from table sql
SQL
0 vote322 views1 answer
Create table like sql
SQL