Which query gives employees earning exactly 50000 OR NULL salary? #sql #query

In SQL, you cannot compare NULL using = or !=.
Instead, you must use:
🔹 IS NULL → to check if a value is NULL
🔹 IS NOT NULL → to check if a value is not NULL

So the correct and valid query is:
SELECT * FROM employees WHERE salary = 50000 OR salary IS NULL;
This ensures:

Employees with exactly 50000 salary are included
Employees with NULL salary are also included
Options A, C, and D are either invalid or logically incorrect due to misuse of NULL comparison.

#SQL #NULLCheck #ISNULL #SQLQuery #SQLMCQ #EzzyByte #LearnSQL
💡 Follow EzzyByte to master SQL logic and crack tricky queries with ease!

Видео Which query gives employees earning exactly 50000 OR NULL salary? #sql #query канала Ezzy Byte