/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

3 votes105 views1 answer
Fk in insert mysql
SQL
0 vote108 views1 answer
How to alter length character varying postgres
SQL
0 vote97 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote100 views1 answer
Sintaxis SELECT sql
SQL
3 votes101 views3 answers
Mysqldump: couldn
SQL
0 vote104 views1 answer
Phpmyadmin tabellentyp ändern
SQL
103 votes279 views2 answers
Sql server LIKE '%%'
SQL
0 vote147 views1 answer
Having all mysql
SQL
0 vote119 views1 answer
Mariadb change column type
SQL
15 votes104 views6 answers
Psql
SQL