Re: SQL to retrieve min value of the combination

Use this one , the same but easier
 select *
 from (

     select col1, min(col3)
     from   x
     group by col1
     )

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:D_6dneS_LcPC0WGiRVn-jg_at_comcast.com...
> question's a little vague, but assuming you are trying to get records for
> the minimum values of the first and third column, for all rows in a table,
> you could try a subquery like
>
> select *
> from x
> where (col1, col3) in (
> select col1, min(col3)
> from x
> group by col1
> )
>
> but don't try this until you understand why it works ;-)
>
> -- mcs
>
>
> "Ravindra Harve" <rharve_at_hotmail.com> wrote in message
> news:835dd0ad.0401070930.575a25ba_at_posting.google.com...
> | 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 ?
>
>
Received on Fri Jan 09 2004 - 02:44:08 CET