What is the result, when NULL is compared with NULL?
- 22 Answers
- 47852 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / affan shemle
It is absolutely perfect to compare NULL with NULL. It
yields the result NULL. For those who are saying the result
is FALSE they are taking the answer from IF THEN ELSE. In
all the above answers supported by IF Statement there is a
catch. The result of IF is a Boolean. A Boolean can hold
TRUE, FALSE or NULL. So when you compare NULL vs NULL as a
condition of IF THEN, it returns NULL so the controller goes
to ELSE skipping the IF. Makes sense???
/
AFFAN SHEMLE
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What are character functions in sql?
How to add, remove, modify users using sql?
What is full join?
What is view explain with example?
What is a design view?
What is record variable?
How do you run a query?
What is the advantage of nosql?
What is integrity in sql?
What are the key differences between SQL and PL SQL?
Is json a nosql?
Define commit, rollback and savepoint?
What is ttitle and btitle?
What is string join?
What is mdb stand for?
