/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

20 votes147 views2 answers
Counting in sql
SQL
1 vote146 views1 answer
Find logged in users mysql
SQL
1 vote178 views1 answer
Convert to hexadecimal sql
SQL
22 votes165 views3 answers
Remove all records from table mysql
SQL
0 vote151 views1 answer
Tsql default value when no value returned by query
SQL
0 vote173 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote161 views1 answer
Horizontal join sqlite
SQL
0 vote159 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote168 views1 answer
Sql select max value from multiple rows
SQL
16 votes192 views3 answers
Order by sql query
SQL