a. select * from Emp where null = null; null= null is always false os no

what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;

Question Posted / anil patel

Answer Posted / anil patel

a. select * from Emp where null = null;

null= null is always false os no rows returns.

b. select * from Emp where 1=1;

it returns all rows

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to change the name of a database user?

945

Explain iaas, paas and saas?

How many databases Microsoft SQL server provides?

1069

What programming language would you use to create embedded functions in ssrs?

180

What is query and its types?

903

How do clustered indexes store data?

1085

Explain primary key, foreign key and unique key?

971

What is sql azure database?

206

How you can minimize the deadlock situation?

1016

How to connect Azure federated root database and apply federation in entity framework?

107

What is clustered vs nonclustered index?

931

How to locate and take substrings with charindex() and substring() functions?

995

What is table-valued sub query?

948

What is tempdb database? : SQL Server Architecture

1168

What do you understand by sql server agent?

966