SELECT DISTINCT
NVL (OTHER_NUM, ' ') AS "fileName"
FROM
BIZ_CALL_RECORD A
WHERE
A .DEL_FLAG = 0
AND START_TIME >= TO_DATE (
'20180721',
'yyyy-MM-dd HH24:MI:SS'
)
AND START_TIME <= TO_DATE (
'20180724',
'yyyy-MM-dd HH24:MI:SS'
)
AND NOT EXISTS (
SELECT
NVL (OTHER_NUM, ' ') AS "fileName"
FROM
BIZ_CALL_RECORD
WHERE
OTHER_NUM = A .OTHER_NUM
AND START_TIME < TO_DATE (
'20180721',
'yyyy-MM-dd HH24:MI:SS'
)
OR START_TIME > TO_DATE (
'20180724',
'yyyy-MM-dd HH24:MI:SS'
)
)
uj5u.com熱心網友回復：
請問這條sql哪塊寫的有問題，查出來的結果集為空uj5u.com熱心網友回復：
子查詢 START_TIME < TO_DATE ('20180721',
'yyyy-MM-dd HH24:MI:SS'
)
OR START_TIME > TO_DATE (
'20180724',
'yyyy-MM-dd HH24:MI:SS'
) 整個用（）包起來
uj5u.com熱心網友回復：
列出一些資料看看。uj5u.com熱心網友回復：
我們并不了解樓主的資料，沒辦法回答，就樓主給出的SQL看，暫時沒看出導致結果為空的因素。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/19579.html
標籤：開發
下一篇：oracle資料庫