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

Report message to a moderator

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: 913
Registered: March 2005
Location: Netherlands
Senior Member
Yes it does, under calculations. However, I believe you need rank, not max.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 08:53:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.