From: mcstockX@Xenquery   
      
   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)