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
Vjeko
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)

Report message to a moderator

Previous Topic: limiting in the where criteria while using an outerjoin
Next Topic: SELECT without FROM in Oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 26 20:44:54 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.