SQL Server:

yangn (Raymond)
select * from employee where salary= (
select top 1 salary from employee
where salary not in (select distinct top 4 salary from employee order by salary )
order by salary )
2002-2-18 -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: have a employee table like this, find the 5th highest salary in it

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