Interested to Buy Any Domain ? << Click Here >> for more details...
What is the result, when NULL is compared with NULL?
- 22 Answers
- 51739 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 does partition by mean in sql?
State few characteristics of pl/sql?
What is the difference between microsoft access and sql?
Can you call pl/sql package functions from within a fast formula?
What is sql keyword?
What is a full join sql?
Explain the select statement in sql?
Can we rename a column in the output of sql query?
How to select 10 records from a table?
What are the benefits of pl/sql packages?
How do I debug a stored procedure?
what tools available for managing mysql server? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
i have some prob lem to tell me about my self in interview first round ...
How many types of relationship are there?
