SELECT DISTINCT
NVL (OTHER_NUM, ' ') AS "fileName"
The FROM
BIZ_CALL_RECORD A
WHERE
A. DEL_FLAG=0
AND START_TIME & gt;=TO_DATE (
'20180721',
'- dd yyyy - MM HH24: MI: SS'
)
AND START_TIME & lt;=TO_DATE (
'20180724',
'- dd yyyy - MM HH24: MI: SS'
)
AND NOT the EXISTS (
SELECT
NVL (OTHER_NUM, ' ') AS "fileName"
The FROM
BIZ_CALL_RECORD
WHERE
OTHER_NUM=a. OTHER_NUM
AND START_TIME & lt; TO_DATE (
'20180721',
'- dd yyyy - MM HH24: MI: SS'
)
The OR START_TIME & gt; TO_DATE (
'20180724',
'- dd yyyy - MM HH24: MI: SS'
)
)

CodePudding user response:

Excuse me the SQL which piece of writing has a problem, found out the result of sets of empty

CodePudding user response:

The subquery START_TIME & lt; TO_DATE (
'20180721',
'- dd yyyy - MM HH24: MI: SS'
)
The OR START_TIME & gt; TO_DATE (
'20180724',
'- dd yyyy - MM HH24: MI: SS'
) the () in a piece of paper

CodePudding user response:

List some data to see,

CodePudding user response:

We don't know the building Lord data, can't answer, just the original poster is given SQL, temporarily didn't see the factors lead to the result is empty,