My Answer (in MS SQL), similar like kiwi's
select * from employee
select max(salary) from employee where
salary<(select max(salary) from employee)
anybody knows answer in Informix or DB2?
here is the table, write a query to find out who have second highest salary?