My Answer (in MS SQL), similar like kiwi's

interview (intervieweree)
select * from employee
where salary=(
select max(salary) from employee where
salary<(select max(salary) from employee)

anybody knows answer in Informix or DB2?
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技术讨论