Re: SQL to retrieve min value of the combination

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 Wed Jan 07 2004 - 19:13:49 CET