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
How to find 3rd highest salary of an employee from the employee table in sql?
Which software is used for pl sql programming?
How do I remove all records from a table?
What is the difference between distinct and unique in sql?
How do I find duplicates in two columns?
What is a pdo connection?
Is vs as in pl sql?
What is the syntax to add a record to a table?
what are the properties and different types of sub-queries? : Sql dba
What are the types of subqueries?
How many tables can you join in sql?
How to return multiple rows from the stored procedure?
What is union, minus and interact commands?
What is the maximum size of sqlite database?
What is data type in sql?