Question

Which queries will return all records that do not contain NULL value in value column? Select all that apply.

Cosmo · Accepted Answer

NULL values cannot be compared using the =, != or <> operators. IS NULL and IS NOT NULL operators should be used instead.

Cosmo · Accepted Answer

SELECT * FROM table WHERE value IS NOT NULL

Cosmo · Answer

SELECT * FROM table WHERE value != NULL

Cosmo · Answer

SELECT * FROM table WHERE value <> NULL

Cosmo · Answer

SELECT * FROM table WHERE value IS NOT empty

Cosmo · Answer

SELECT * FROM table WHERE value LIKE NOT NULL