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

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. Received on Thu Jun 15 2000 - 00:00:00 CDT