suppose the name of table is tn:

kiwi (kiwi)
select name, salary from tn tn3
where salary in
select max(salary) from tn t1
where salary not in
select max(salary) from tn t2
2002-2-15 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: here is the table, write a query to find out who have second highest salary?

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论