Home » RDBMS Server » Server Administration » SQL
SQL [message #371585] Thu, 09 November 2000 23:44 Go to next message
subhas
Messages: 1
Registered: November 2000
Junior Member
A table salary is there.
it has only one field, sal number(5).
Pls tell the shortest
query to select the 2 highest salaries.

Report message to a moderator

Re: SQL [message #371587 is a reply to message #371585] Fri, 10 November 2000 02:30 Go to previous messageGo to next message
Dimitar
Messages: 2
Registered: November 2000
Junior Member
!!! Improved version to eliminate null values

try this:

select sal
from ( select nvl(sal,0) from salary
order by sal desc
)
where rownum < 3;

Report message to a moderator

Re: SQL [message #371588 is a reply to message #371585] Fri, 10 November 2000 02:34 Go to previous message
Dimitar
Messages: 2
Registered: November 2000
Junior Member
!!! Improved version to eliminate null values

try this:

select sal
from ( select nvl(sal,0) as sal from salary order by sal desc )
where rownum < 3;

Report message to a moderator

Previous Topic: How to access COM components from the stored Procedures
Next Topic: Dynamic function returning a pl/sql table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 11:54:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.