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

What is database replication? What are the different types of replication you can set up in sql server?

958

Do you know what is xpath?

1083

Why can there be only one clustered index and not more than one?

1002

What are the 10 characteristics of data quality?

951

Is ssrs support other database except ms sql server?

139

what are the core components of SSRS?

129

What is the difference in accessing db between sql server vs sql azure?

174

Tell me about pre-defined functions of sql?

1108

How to add more data to the testing table in ms sql server?

1081

Why and when do stored procedure recompile?

977

Explain transaction server isolation?

1037

how can you attach more than 20 ldf files in sql server

1996

Tell me what is log shipping?

975

please differentiate between delete and truncate?

991

What is t-sql script to take database offline – take database online.

1082