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 -> Are the two SQLs equivalent?

Are the two SQLs equivalent?

From: Jinshan Li <li.js_at_neusoft.com>
Date: 7 Jun 2005 07:07:53 -0700
Message-ID: <b60ce575.0506070607.26fab004@posting.google.com>


Are the two SQLs equivalent? And , you think which is better. 1.FROM table1

    WHERE

     RTRIM(START_DATE||BNK_CD||STN_CD) IN
     (  SELECT MAX(START_DATE)||BNK_CD||STN_CD
        FROM table1    KYO, table2 SYS
        WHERE START_DATE <= SYS.CNTR_DATE
           AND ( DEL_DATE < SYS.CNTR_DATE OR DEL_DATE IS NULL)
        GROUP BY BNK_CD,STN_CD

)

2.FROM table1 BT

    WHERE

      EXISTS
     (  SELECT 'A'
        FROM table1    KYO,  table12 SYS
        WHERE KYO.START_DATE <= SYS.CNTR_DATE
          AND ( KYO.DEL_DATE < SYS.CNTR_DATE OR KYO.DEL_DATE IS NULL)
          AND BT.BNK_CD = KYO.BNK_CD    AND BT.STN_CD = KYO.STN_CD
          having BT.START_DATE = MAX(START_DATE)

)
Received on Tue Jun 07 2005 - 09:07:53 CDT

Original text of this message

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