IS NULL
Find rows with missing values.
Syntax
sql
1SELECT * FROM students
2WHERE phone IS NULL;Example
Find students without phone numbers:
sql
1SELECT * FROM students
2WHERE phone IS NULL;Multiple NULL Checks
sql
1SELECT * FROM students
2WHERE phone IS NULL
3OR email IS NULL;