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 are the advantages of partitioning?

1045

when you create a database how is it stored? : Sql server database administration

940

When columns are added to existing tables, what do they initially contain?

976

How can you set the threshold at which sql server will generate keysets asynchronously?

939

How is sql used in sql server?

941

What is the fastest way to permanently delete a 1 million row table named customers?

1152

what is denormalization and when would you go for it? : Sql server database administration

1116

How do you create type- insensitive operator?

994

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

961

In how many ways you can invoke ssrs reports?

132

Does group by sort data?

846

What is set nocount on?

893

What is a file group?

1018

What are commonly used odbc functions in php?

971

What is a transact-sql statement?

980