/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 vote355 views1 answer
Sql select by content lenght
SQL
1 vote380 views1 answer
Sql in array query
SQL
0 vote370 views1 answer
How to create a table based on another table in mysql
SQL
0 vote397 views1 answer
Get clob size oracle
SQL
3 votes383 views1 answer
Apex set debug level
SQL
7 votes341 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote389 views1 answer
Oracle sql first day of year
SQL
0 vote348 views1 answer
Oracle sql winter time change
SQL
0 vote391 views1 answer
Csv to sqlite python
SQL
0 vote348 views1 answer
Mariadb used space
SQL

Share