/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

10 votes327 views4 answers
Inner join in update query mysql
SQL
0 vote343 views5 answers
Sql table intermédiaire
SQL
0 vote361 views1 answer
Left join vs inner join performance
SQL
2 votes325 views1 answer
Oracle number to percentage
SQL
0 vote376 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
2 votes327 views1 answer
Oracle list grants on procedure
SQL
3 votes347 views2 answers
How to open postgresql in windows
SQL
2 votes387 views1 answer
Sql find not in list
SQL
0 vote297 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote325 views1 answer
Oracle list proxy users
SQL

Share