| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL to retrieve min value of the combination
harve_projects_at_yahoo.com (HRR) wrote:
>Hi,
>
>I have the following table
>
>1001 2 3
>1001 3 5
>1001 5 7
>1002 5 4
>1002 6 2
>
>I need to get a result
>
>1001 2 3
>1002 6 2
>
>How is it possible ?
Column names would have helped..assume a, b and c
Select a,min(b),min(c) from sometable
group by a;
Received on Wed Jan 07 2004 - 12:34:31 CST
 |
 |