What is the result, when NULL is compared with NULL?
Answers were Sorted based on User's Feedback
Answer / kmbkrishnan
if we check a Null value with another Null value as equal,
the result will be false.
|Is This Answer Correct ?||43 Yes||8 No|
Answer / anil kumar abbireddy
NOT EQUAL AND AGAIN ANSWER IS NULL
|Is This Answer Correct ?||14 Yes||2 No|
Answer / 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???
|Is This Answer Correct ?||13 Yes||1 No|
Answer / pavan_1981
i dont know how u can compare a null value with another
null value.i dont find any operator for doing that.
|Is This Answer Correct ?||15 Yes||6 No|
Answer / talent pool
NULL Is An Unknown Value
So We Couldn't Compare it With Other One.This Is Pure
declare @d int
Set @d =null
declare @r int
Print 'Summa Vilayadatha'
|Is This Answer Correct ?||8 Yes||1 No|
Answer / a.jyothsna
One null value is not equal to another null value.
|Is This Answer Correct ?||7 Yes||1 No|
Answer / guest
The answer is NULL vs NULL = FALSE
|Is This Answer Correct ?||9 Yes||5 No|
Answer / kirankumar.vangeti
Null is neither equal to null nor it is not equal to null.
Any comparison to null is evaluated to null.
|Is This Answer Correct ?||3 Yes||0 No|
Answer / brahma
Null means unknown values, but do not compare both null
|Is This Answer Correct ?||2 Yes||0 No|
How can u find column name from a table which have max value in a row.( not max value)
How to update salary of employees department wise?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
how to retrieve the top 3 salaries of the table using rownum
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
difference between cursor and procedure in a package
What is Overloading of procedures ?
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??
Name the tables where characteristics of Package, procedure and functions are stored ?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
difference between pl/sql table and normal pl/sql table
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c