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)

)

)

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 -04:00

2002-2-18 -04:00