/SQL/2nd max salary query in sql

2nd max salary query in sql

2nd max salary query in sql

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

0

Second max salary in sql

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

0

Similar codes

5 votes117 views1 answer
Get column name sql server
SQL
0 vote117 views1 answer
Sql show founctions
SQL
0 vote120 views1 answer
Mysql group by derived column
SQL
0 vote117 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote117 views1 answer
Two inner joins sql
SQL
0 vote143 views2 answers
Sql unique
SQL
-1 vote126 views1 answer
How to Activate the database
SQL
0 vote120 views1 answer
No suitable driver found for sqlite
SQL
3 votes118 views2 answers
Install mysql powershell
SQL
1 vote123 views1 answer
Oracle compile schema
SQL

Share