From: mcstockX@Xenquery   
      
   Julia,   
      
   Not the same by any means.   
      
   Your select * does absolutely nothing -- the subquery results are simply   
   passed thru unchanged   
      
   Your subquery contains only two columns -- the assumption is that all   
   columns should be displayed   
      
   Try them both on the EMP table with the empno, deptno, and sal in the   
   resultset and dept and sal in the subquery ("Write a report that lists the   
   lowest paid employees in each department")   
      
   -- mcs   
      
   "Julia Sats"  wrote in message   
   news:iKnLb.79822$BA6.1688941@news20.bellglobal.com...   
   | 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)