Home » RDBMS Server » Server Administration » Top 100 report
Top 100 report [message #371823] Mon, 11 December 2000 13:47 Go to next message
M. Buxton
Messages: 2
Registered: December 2000
Junior Member
How can I limit the number of rows in a report? I'd like to perform calculations after I've retrieved and displayed the top 100 values. Thanks for your help.

Report message to a moderator

Re: Top 100 report [message #371836 is a reply to message #371823] Tue, 12 December 2000 13:29 Go to previous messageGo to next message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
You can filter the where condition by adding
where rownum <101 this will retrieve only 100 rows.
In case you want this from Oracle Reports tool
let me know
Madhav

Report message to a moderator

Re: Top 100 report [message #371837 is a reply to message #371823] Tue, 12 December 2000 13:35 Go to previous messageGo to next message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
You can filter the where condition by adding
where rownum <101 this will retrieve only 100 rows.
In case you want this from Oracle Reports tool
let me know
Madhav

Report message to a moderator

Re: Top 100 report [message #372101 is a reply to message #371823] Wed, 10 January 2001 06:06 Go to previous message
Sandeep Udupa
Messages: 9
Registered: January 2001
Junior Member
SELECT * FROM

WHERE rownum <= 0
MINUS
SELECT * FROM

WHERE rownum <101;

Report message to a moderator

Previous Topic: select statement ...
Next Topic: Business Days
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 02:16:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.