/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 vote145 views1 answer
Oracle allow space to user
SQL
0 vote138 views2 answers
Database owner can't create new tables postgres
SQL
-1 vote135 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote150 views1 answer
PGSQL dynamic table name
SQL
0 vote129 views2 answers
Find Overlapping sql
SQL
0 vote141 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
-1 vote216 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote143 views1 answer
Raise application error in oracle
SQL
0 vote229 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote128 views1 answer
Find and replace database table phpmyadmin
SQL