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

Report message to a moderator

Previous Topic: UNWANTED AUTO EXTEND
Next Topic: DELETE COLUMN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:46:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.