Google News
logo
MySQL - Quiz(MCQ)
What does comparing a known value with NULL result into?
A)
null
B)
zero
C)
a positive value
D)
a negative value

Correct Answer :   null


Explanation : In MySQL, NULL is not comparable to other known values. It will result in a NULL when compared to any value. The following statement would result in four NULLs : ‘SELECT NULL = 0, NULL < 0, NULL <> 0, NULL > 0’.

Advertisement