×

Loading...

select * from name_salary where salary < (select max(salary) from name_salary) and rownum < 2; (FOR ORACLE)

bloor(不老)
(#369965@0)
Last Updated: 2002-2-15
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

here is the table, write a query to find out who have second highest salary?
枫下论坛主坛 /  工作学习 /  IT技术讨论