| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |