Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Are the two SQLs equivalent?
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
)