Home » RDBMS Server » Server Administration » Re: @corelated subquery
Re: @corelated subquery [message #370994] Tue, 01 August 2000 20:13
Robert
Messages: 43
Registered: August 2000
Member
I would do this:
accept putnum prompt 'enter a number:'
select salary, name
from wage
where salary>any
(select salary
from wage
where rownum<&putnum)
order by salary desc
Previous Topic: UNWANTED AUTO EXTEND
Next Topic: DELETE COLUMN
Goto Forum:
  


Current Time: Sat Oct 24 04:03:00 CDT 2020