Sql 2nd highest salary

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 2nd highest salary

select *from employee 
group by salary 
order by  salary desc limit 1,1;

Nth highest salary in sql

Here is the solution for nth highest
salary from employees table 

SELECT FIRST_NAME , SALARY FROM 
(SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER
(ORDER BY SALARY DESC) AS SALARY_RANK
FROM EMPLOYEES)
WHERE SALARY_RANK = n;

Second max salary in sql

SELECT MAX(SALARY) 'SECOND_MAX' FROM EMPLOYEES
WHERE SALARY <> (SELECT MAX(SALARY) FROM EMPLOYEES);

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 vote205 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
1 vote210 views1 answer
Update from table tsql
SQL
0 vote226 views1 answer
Minus equivalent in my sql
SQL
0 vote198 views1 answer
Case when with count and combining similar values in sql
SQL
15 votes209 views3 answers
Mysql update add to existing value
SQL
10 votes225 views4 answers
Inner join in update query mysql
SQL
14 votes195 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
65 votes575 views6 answers
Sql add column to table
SQL
0 vote207 views1 answer
Mssql check if date is greater than today
SQL
1 vote209 views2 answers
How to drop a unique constraint in sql
SQL