Question

Consider the following query: SELECT name FROM class WHERE subject NULL: Which comparison operator may be used to fill the blank space in above query? LIKE IS IS NOT

Answer 1

SELECT name FROM class WHERE subject IS NOT NULL

IS NOT NULL

• In SQL, the IS NOT NULL condition is used to check for non-NULL values. If a non-NULL value is detected, it returns TRUE; otherwise, it returns FALSE. In a SELECT, INSERT, UPDATE, or DELETE statement, it can be utilized.
• The requirement for the IS NOT NULL operator is met if the column has a value that is not null, or if the expression immediately preceding the IS NOT NULL keywords does not evaluate to null.