×

Loading...

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

bloor (不老)
(#369965@0)
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技术讨论