Home » RDBMS Server » Server Administration » Re: How to find the 4th maximum sal?
Re: How to find the 4th maximum sal? [message #371019] Wed, 09 August 2000 02:25
Messages: 15
Registered: August 2000
Junior Member
First, I must thanks to Mooh Dadi from www.oraclefans.com because I saw this great solution in one of Mooh's replies.

select t1.name,t1.sal
from table t1
where 4=(select count(*) from table t2 where t2.sal>=t1.sal)
Previous Topic: limiting in the where criteria while using an outerjoin
Next Topic: SELECT without FROM in Oracle 8
Goto Forum:

Current Time: Mon Dec 05 11:35:43 CST 2022