Hi, If you comapare null=null then it return 0 rows selected. Check the r

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

Question Posted / nhajare

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

Please Help Members By Posting Answers For Below Questions

what are sequences

1748

What are all the different types of indexes?

1147

What does t sql mean?

948

What does sign mean sql?

1113

What is query optimization in sql?

985

What is localdb mssqllocaldb?

1068

Does view store data in sql?

969

What is difference between pls_integer and integer?

964

Compare sql & pl/sql

1141

Is left join and outer join same?

1070

What do you understand by case manipulation functions?

1034

Explain how to use transactions efficiently : transact sql

980

How delete all data from table in sql?

1019

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

Does asenumerable execute the query?

1046