Home » Developer & Programmer » Reports & Discoverer » junior (Dicoverer 10g)
icon7.gif  junior [message #294281] Thu, 17 January 2008 01:29 Go to next message
Messages: 47
Registered: January 2008
Hi Gurus,

I am new to the forum and i have an issue ,
iam working on discoverer 10g 10.1.2..
I'd like to retreive just one row of data from a set of rows, based on which row has the highest value in a given data field. I believe Discoverer used to have a MAX() function, but that doesn't seem to be the case with 10g.
plz help me...


Re: junior [message #294720 is a reply to message #294281] Fri, 18 January 2008 10:52 Go to previous messageGo to next message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Yes it does, under calculations. However, I believe you need rank, not max.
Re: junior [message #295112 is a reply to message #294720] Mon, 21 January 2008 06:30 Go to previous message
Messages: 6
Registered: May 2007
Location: Bucharest
Junior Member
skooman is right, i would append, even dense_rank.

My advice is.. do most of the job directly from SQL in the database, then go work with any application that will use the database.

Previous Topic: Drill Down Report in Report 10g
Next Topic: Worksheet Link
Goto Forum:

Current Time: Fri Jul 28 10:01:06 CDT 2017

Total time taken to generate the page: 2.31809 seconds