Re: Oracle Guru's: How to return additional row information

If your interested in charting that cpu load check out my GNUmetrics application. Will have a new version out this week.

http://www.gnumetrics.com
http://www.mrtg.org

In article <8ibi1o$gjo$1_at_nnrp1.deja.com>,   mikea730_at_my-deja.com wrote:
> Thanks for the information. The select in the from statement did the
> trick!!!
>
> Thanks,
> Mike
>
> In article <8i704l$3bg$1_at_nnrp1.deja.com>,
> mikea730_at_my-deja.com wrote:
> > Anyone know a trick to do the following?
> >
> > Running Oracle 8i on Solaris 2.7
> >
> > In one select statement I need to determine the MAX() value for a
> > column, then for the row that was found, return other information.
 For
> > example:
> >
> > Table_A conatains:
> > server_name VARCHAR2(30)
> > cpu_load NUMBER,
> > sample_time DATE,
> >
> > In one select statement I'd like to see the following returned
 (GROUPED
> > BY server_name)
> >
> > server_name MAX(cpu_load) sample_time
> > ----------- ------------- --------------------
> > server_1 100 4/10/2000 10:23:10
> > server_2 56 5/23/2000 12:45:23
> > server_3 33 2/12/2000 14:23:32
> >
> > The select statement to acheive this would be something like
> >
> > SELECT
> > server_name,
> > MAX(cpu_load)
> > FROM
> > Table_A
> > GROUP BY
> > server_name
> >
> > But the question is, how do I get the sample_time for the rows
 returned?
> >
> > Thanks in advance!!!
> >
> > Mike
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 05 2000 - 00:00:00 CDT