SQL to retrieve min value of the combination

From: Ravindra Harve <rharve_at_hotmail.com>
Date: 7 Jan 2004 09:30:57 -0800
Message-ID: <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 - 18:30:57 CET

Original text of this message