Question

197 viewsMay 29, 2023Otherssql-server

0

Sandhya 2.52K May 26, 2023 0 Comments

Give an example for IS NULL and IS NOT NULL?

score 0 · Answer 1 · 2023-05-29T07:47:49+00:00

For example,

— select rows with NULL email values SELECT * FROM Employee WHERE email IS NULL; Run Code.
— select rows where email is not NULL SELECT * FROM Employee WHERE email IS NOT NULL; Run Code.
SELECT COUNT(*) FROM Employee WHERE email IS NULL; Run Code.

Questions