What is the result, when NULL is compared with NULL?
Answers were Sorted based on User's Feedback
Answer / pravin
It is not possible to compare two nulls with each other.
Still if we want to compare null then we have isnull
operator.
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / gaurav arora
The answer-6 is quite matching with my stuff. Let me clear
it in more writting:
1. When we compare two nulls then the result
always 'false'. The main reason is the null is not a value
its neither an empty nor a empty space, so the actual
result is null which places as null.
2. When we compare a null with another which has some value
like some int value then the result is false. The actual
result is false and not null.
Consider the following examples:
--null = null is null which is false
Declare @intNull1 int
Set @intNull1 =null
Declare @intNull2 int
Set @intNull2=null
If @intNull1=@intNull2
Print 'null = null is true'
Else
Print 'null = null is false'
--Now assign some value
Set @intNull1 = 1
If @intNull1=@intNull2
Print 'null = int value is true'
Else
Print 'null = int value is false'
Thanks,
Gaurav Arora
http://stuff4mdesktop.blogspot.com/
Is This Answer Correct ? | 1 Yes | 2 No |
how to rename an existing column in a table? : Sql dba
oracle is compiler or interpretter,can any one tell me the answer?
what is inline view?
How do you update a value in sql?
What is trigger price?
What is extent clause in table space?
Is primary key clustered or nonclustered?
Can we insert in view in sql?
overloading of stored procedure is possible in oracle?
Is pl sql better than sql?
Why we use join in sql?
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?