/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

-1 vote135 views3 answers
Mysql get age from date
SQL
5 votes147 views2 answers
Mysql drop table cascade
SQL
0 vote154 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote133 views1 answer
How to create an SQL save method in ruby
SQL
0 vote166 views1 answer
Mysql remove last character
SQL
1 vote144 views1 answer
Mysql get latest duplicate rows
SQL
-1 vote152 views1 answer
Su: Authentication failure mysql
SQL
0 vote192 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote165 views2 answers
What is the default password for sql server sa
SQL
0 vote141 views1 answer
Power query case when
SQL

Share