/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 vote338 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote406 views2 answers
Intersect sql
SQL
0 vote361 views1 answer
How to use lower case in mysql
SQL
0 vote350 views1 answer
Get records in sql according to month name and count
SQL
0 vote384 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote356 views1 answer
Which MySQL data type to use for storing boolean values
SQL
3 votes341 views1 answer
Oracle user quota unlimited
SQL
7 votes375 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote371 views2 answers
Py sqlite if entry exists
SQL
3 votes399 views2 answers
Sqlite show table structure
SQL