What is the result, when NULL is compared with NULL?

Answers were Sorted based on User's Feedback

What is the result, when NULL is compared with NULL?..

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

What is the result, when NULL is compared with NULL?..

NOT EQUAL AND AGAIN ANSWER IS NULL

 Is This Answer Correct ? 14 Yes 2 No

What is the result, when NULL is compared with NULL?..

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

What is the result, when NULL is compared with NULL?..

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

What is the result, when NULL is compared with NULL?..

DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;

It will alwayz return FAIL.

 Is This Answer Correct ? 12 Yes 3 No

What is the result, when NULL is compared with NULL?..

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
Set @r=null
if @d=@r
Print 'Hi'
Else

 Is This Answer Correct ? 8 Yes 1 No

What is the result, when NULL is compared with NULL?..

One null value is not equal to another null value.

 Is This Answer Correct ? 7 Yes 1 No

What is the result, when NULL is compared with NULL?..

The answer is NULL vs NULL = FALSE

 Is This Answer Correct ? 9 Yes 5 No

What is the result, when NULL is compared with NULL?..

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

What is the result, when NULL is compared with NULL?..

Null means unknown values, but do not compare both null
values

 Is This Answer Correct ? 2 Yes 0 No

More SQL PLSQL Interview Questions

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

how can you see all indexes defined for a table? : Sql dba

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

How to change sql*plus system settings?

Can we create table in function?

What are the different types of joins and explain them briefly.

what is sql.

What is minus?

what is the difference between the query and corelated query

how many sql dml commands are supported by 'mysql'? : Sql dba

What is trigger in sql?

Categories