Home » Developer & Programmer » Reports & Discoverer » junior (Dicoverer 10g)
icon7.gif  junior [message #294281] Thu, 17 January 2008 01:29 Go to next message
amritaseema
Messages: 47
Registered: January 2008
Member
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...

Thanks

Amrita
Re: junior [message #294720 is a reply to message #294281] Fri, 18 January 2008 10:52 Go to previous messageGo to next message
skooman
Messages: 912
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
mihaiv
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.

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


Current Time: Wed Dec 07 10:51:23 CST 2016

Total time taken to generate the page: 0.11269 seconds