Interested to Buy Any Domain ? << Click Here >> for more details...
What is the result, when NULL is compared with NULL?
- 22 Answers
- 51576 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
How do you copy a table in sql?
Do prepared statements prevent sql injection?
Which sql statement is used to delete data from a database?
I need a function for a train ticket reservation please answer it thanks in advance
Why indexing is needed?
How do I create a memory optimized filegroup?
What is varchar used for?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Define a temp table?
What are the types of variables use in pl sql?
What is the unique index?
What is pl sql in oracle?
How do I send sql query results to excel?
What language is oracle sql developer?
Why do we need a foreign key?
