From: julia.sats@sympatico.ca   
      
   Use this one , the same but easier   
    select *   
    from    (   
        select col1, min(col3)   
        from   x   
        group by col1   
        )   
      
   "Mark C. Stock"  wrote in message   
   news:D_6dneS_LcPC0WGiRVn-jg@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"  wrote in message   
   > news:835dd0ad.0401070930.575a25ba@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 ?   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)