OraFAQ Forum: Server Administration » Re: @corelated subquery

Home » RDBMS Server » Server Administration » Re: @corelated subquery

Thu, 24 August 2000 04:02

Jaya Kumar NM
Messages: 11
Registered: August 2000

Junior Member

select a.emp,a.sal from emp a where &no >
(select count(b.sal) from emp b where
a.sal < b.sal)
and a.sal is not null
order by a.sal desc

Previous Topic:	numeric varchar2
Next Topic:	Error while adding not null constraint

Goto Forum:

]

Current Time: Tue Mar 11 22:55:04 CDT 2025