almost correct

interview (intervieweree)
the answer is


select * from employee where salary=
(
select max(salary) from employee
where salary not in
(
select top 4 salary from employee order by salary desc)
)
)
(#372542@0)
2002-2-18 -05:00

回到话题: have a employee table like this, find the 5th highest salary in it

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

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