×

Loading...

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

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

anybody knows answer in Informix or DB2?
Report