SQLD · 모의고사 11회 · 34번

Question

EMPLOYEE 테이블에서 PHONE_NUMBER 값이 NULL이 아닌 행을 조회하는 SQL로 가장 적절한 것은?

Accepted Answer

SELECT * FROM EMPLOYEE WHERE PHONE_NUMBER IS NOT NULL;

Answer

SELECT * FROM EMPLOYEE WHERE PHONE_NUMBER <> NULL;

Answer

SELECT * FROM EMPLOYEE WHERE PHONE_NUMBER NOT NULL;

Answer

SELECT * FROM EMPLOYEE WHERE PHONE_NUMBER != NULL;