What is the result, when NULL is compared with NULL?
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 is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is restrict in sql?
Is nosql relational?
Determine if oracle date is on a weekend?
Does truncate free space?
How do you use a while loop in pl sql?
How many types of relationship are there?
What is pl/sql table? Why is it used?
Does sql between include endpoints?
What is sql and its types?
What is the difference between left outer join and left join?
What do you mean by field in sql?
How do I find duplicates in two columns?
Can we insert data into materialized view?
Should I use mbr or gpt?