SQLD CBT 기출문제 예상문제 944번

다음 문제를 풀어보세요.

다음 보기 SQL의 실행 결과가 다른 하나를 고르시오.

[ ACCOUNT ]



ACCT_NO
START_DATE
END_DATE




A101
2023-01-01
2023-06-30


A102
2023-03-01
NULL


A103
2023-07-01
2023-12-31


A104
2023-09-01
NULL

SELECT COUNT(*) 
FROM   ACCOUNT 
WHERE  NVL( END_DATE, DATE '9999-12-31'  ) >= DATE '2023-08-01';

SELECT COUNT(*) 
FROM   ACCOUNT 
WHERE  COALESCE( END_DATE, DATE '9999-12-31' ) >= DATE '2023-08-01');

SELECT COUNT(*) 
FROM   ACCOUNT 
WHERE  DECODE( END_DATE, NULL, DATE '9999-12-31', END_DATE ) >= DATE '2023-08-01';

SELECT COUNT(*) 
FROM   ACCOUNT 
WHERE  NVL2( END_DATE,  DATE '9999-12-31', END_DATE )  >= DATE '2023-08-01';