Home » RDBMS Server » Server Administration » Top x records
Top x records [message #371634] Fri, 17 November 2000 04:27 Go to next message
Walter Lee
Messages: 1
Registered: November 2000
Junior Member
Hi,

Is there a quick way in oracle sql to retrieve for example the top 5 records from a query.

For example in MS SQL Server one can run "select top 5 * from tablename"

Thanks,
WL

Report message to a moderator

Re: Top x records [message #371636 is a reply to message #371634] Fri, 17 November 2000 05:39 Go to previous messageGo to next message
Tittom
Messages: 15
Registered: November 2000
Junior Member
You can try this :

select * from tablename where rownum<=5

I hope this will help you
Tittom.

Report message to a moderator

Re: Top x records [message #371640 is a reply to message #371634] Sat, 18 November 2000 00:31 Go to previous message
Raj_adhikari
Messages: 1
Registered: November 2000
Junior Member
try this :
suppose your query is based on salary then the query would be like this-
select distinct sal from tmp a
where 5>(select count(*) from tmp b
where a.sal<b.sal) order by sal desc

regards....
Rajendra

Report message to a moderator

Previous Topic: Urgent: UTL_FILE PL/SQL Reference Package
Next Topic: appending 2 digits from year to sequence number.....
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 07:10:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.