Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query help

Re: query help

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 24 Jul 2004 13:31:18 -0400
Message-ID: <pan.2004.07.24.17.31.18.434081@sbcglobal.net> 





On Sat, 24 Jul 2004 16:37:56 +0000, Michael J. Moore wrote:


> SQL> select el1,el2,el3 from test a




>   2  where

>   3  not exists (select * from test b

>   4              where b.el2 = a.el2

>   5              and   b.el3 < a.el3);




This is a very smart solution. Thanks, Michael!


-- 
A city is a large community where people are lonesome together.


Received on Sat Jul 24 2004 - 12:31:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US