Answer / kmbkrishnan

if we check a Null value with another Null value as equal,
the result will be false.

Answer / anil kumar abbireddy

NOT EQUAL AND AGAIN ANSWER IS NULL

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???
/
AFFAN SHEMLE

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.

Answer / sant

In oracle the below eg will help you to clear this:

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.

Answer / talent pool

NULL Is An Unknown Value
So We Couldn't Compare it With Other One.This Is Pure
Correct Answer.

declare @d int
Set @d =null
declare @r int
Set @r=null
if @d=@r
Print 'Hi'
Else
Print 'Summa Vilayadatha'

Answer / a.jyothsna

One null value is not equal to another null value.

Answer / guest

The answer is NULL vs NULL = FALSE

Answer / kirankumar.vangeti

Null is neither equal to null nor it is not equal to null.
Any comparison to null is evaluated to null.

Answer / brahma

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

Can a select statement fire a trigger?

0 Answers  

How can check sql version from command line?

0 Answers  

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

Is pl sql useful?

0 Answers  

Which are the different types of indexes in sql?

0 Answers  

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

What are the parts of a basic sql query?

0 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

Explain the steps needed to create the scheduled job?

0 Answers  

What are instead of triggers?

0 Answers  

C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

0 Answers