Home » RDBMS Server » Server Administration » Re: @corelated subquery
Re: @corelated subquery [message #371081] 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 Oct 20 10:18:39 CDT 2020