/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

0 vote255 views1 answer
Cannot pip install mysqlclient
SQL
0 vote245 views1 answer
T-sql delete view if exists
SQL
8 votes231 views3 answers
Alter user root mysql
SQL
0 vote232 views1 answer
Check if database exists sql
SQL
10 votes238 views4 answers
How to alter table name in mysql
SQL
6 votes228 views4 answers
Mysql group by month
SQL
4 votes221 views2 answers
How to insert ip address in mysql using php
SQL
0 vote223 views1 answer
Oracle sql generate list of days
SQL
22 votes220 views3 answers
Join three tables sql
SQL
2 votes216 views1 answer
Select * from table where name like
SQL

Share