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 add more data to the testing table in ms sql server?

1179

What is difference between inner join and join?

1098

What is user-defined scalar function?

1021

Name the different type of indexes in sql?

1028

What are the character string functions supported by sql server 2005?

1090

What is side by side migration in sql server?

1189

Write a query to find 5th highest amount paid from the customer table.

997

How do you delete duplicate records in sql server?

1136

Define a cross join?

1088

Explain about Joins?

1042

What is normalization and its types?

1081

What are the five major components of a dbms?

978

What happens if you add a new index to large table?

990

How to create a user to access a database in ms sql server using "create user" statements?

1005

What is subquery? Explain the properties of a subquery?

1044