/SQL/Sql find second highest salary employee

Sql find second highest salary employee

Sql select second max

Both options you find max as a subset and then exclude from main select
sql> SELECT MAX( col ) FROM table
 	WHERE col < ( SELECT MAX( col ) FROM table);
sql> SELECT MAX(col) FROM table 
WHERE col NOT IN (SELECT MAX(col) FROM table);

Source: stackoverflow.com

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;

Sql highest salary by location

/*  Highest salary by Department/Location   */
SELECT e.ename, e.sal, e.deptno, d.loc
FROM emp e
JOIN dept d
ON e.deptno = d.deptno
WHERE e.sal in
( 	
  	select max(sal) 
  	from emp 
  	group by deptno
)

Similar codes

-1 vote122 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
6 votes135 views5 answers
Sql add months to date
SQL
0 vote138 views1 answer
Time mysql w3
SQL
0 vote120 views1 answer
Alter table fulltext
SQL
0 vote141 views1 answer
How to change mysql root password in windows 10
SQL
0 vote138 views1 answer
Merge clause with inner join
SQL
0 vote134 views1 answer
Psql get table data types
SQL
0 vote125 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote123 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote134 views1 answer
Dump db only triggers mysql
SQL