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

Answer Posted / nhajare

Hi,
If you comapare null=null then it return 0 rows selected.
Check the result of this query...

select * from table_name where null=null;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cross join sql?

684


What is sql select statement?

703


What is on delete set null?

765


what are numeric data types? : Sql dba

761


Can we use commit inside a trigger?

763






What is an intersect?

865


What is restrict in sql?

743


How many types of triggers are there in pl sql?

781


How do I find duplicates in sql?

690


How do I get sql certification?

704


What is aggregate function in sql?

738


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2189


What is rename command in sql?

667


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

758


Can we use view in stored procedure?

700