u can not compare two nulls null means nothing.so ANS 1:no row ANS 2:A

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

Question Posted / nitin yadav(nitin.yadav.india@

Answer Posted / nitin yadav(nitin.yadav.india@

u can not compare two nulls

null means nothing.so
ANS 1:no row
ANS 2:All row (because of 1=1 is always true for all rows)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure Fabric?

112

Explain powershell included in sql server 2008?

1117

What stored by the model? : sql server database administration

1004

What is 'Join' and explain its various types.

1213

How do you create a clustered index?

1130

Which are the third-party tools used in sql server and why would you use them?

968

Explain the properties of subqueries in sql server?

1143

Can we insert data into a view?

1195

Explain steps of normalization?

1067

What does <> symbol mean?

1030

What is command parameter in ssrs?

166

How to divide query output into multiple groups with the group by clause in ms sql server?

1093

Is truncate a dml command?

1001

ow to bring suspect mode datbase online from scratch

1860

Difference between report and query parameter. Why do we need different type of parameter?

1011