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
)
)
(#369970@0)
2002-2-15 -05:00

回到话题: here is the table, write a query to find out who have second highest salary?

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=369970