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

How does postgresql compare to oracle/db2/ms sql server/informix?

556


What are the events on which a database trigger can be based?

585


What is sql comments?

646


How do you copy a table in sql?

555


How does sql store data?

480






What are the types of triggers in sql?

492


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

535


what are the different functions in sorting an array? : Sql dba

577


What is sql exception?

513


What is database sql?

537


What is the usage of distinct keyword?

625


What is trigger in flip flop?

512


What is sorting in sql?

499


What is the use of procedures?

535


What is user in sql?

571