XPost: comp.databases.oracle.misc, comp.databases.oracle.server   
   From: gusz1@freemail.hu   
      
   Take a look at the following example:   
      
   table T(i INTEGER, j INTEGER)   
      
   I want to get the value of i where j is minimal and some conditions apply.   
      
   (1)   
   SELECT i FROM T   
   WHERE [condition]   
   AND j   
   IN (SELECT min(j) FROM T WHERE [condition])   
      
   The best would be if such a syntax was allowed (which it isn't):   
   SELECT i, min(j) FROM T WHERE [condition]   
      
   How can I rewrite the SELECT statement in (1) such that [condition] doesn't   
   have to be typed in twice? Or how can I achieve the same thing in some other   
   way? (I am open to other solutions as well as long as they are inside the   
   limits of Oracle PL/SQL.)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)