Examveda
Examveda

What operator tests column for the absence of data?

A. EXISTS operator

B. NOT operator

C. IS NULL operator

D. None of these

Answer: Option C

Solution(By Examveda Team)

Always use IS NULL to look for NULL values.

Syntax:

SELECT "column_name"
FROM "table_name"
WHERE "column_name" IS NULL

Join The Discussion

Related Questions on Sql Miscellaneous