select * from Emp where null = null; null can not be equal to null.So,Co

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

Question Posted / jay vardhan singh

13 Answers
24217 Views
Patni, I also Faced
E-Mail Answers

Answer Posted / jay vardhan singh

select * from Emp where null = null;

null can not be equal to null.So,Condition is not satisfied.
So,it will give only column name.

select * from Emp where 1=1;

1 is always equal to 1.So,Condition is satisfied ,So It
will give all data which is present in table.

Is This Answer Correct ?

23 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain Geometry datatype in sql server 2008 with example

957

How does using a separate hard drive for several database objects improves performance right away?

915

what exactly sql injuction.how to overcome.....

2516

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

1062

What is isnull() operator?

1018

Explain about Normalization?

1040

What is query cost in sql server?

978

What is b tree index?

902

How to get the query of a table in sql server?

878

What is raid, and how it can influence database performance?

1044

Can you tell me about the concept of ER diagrams?

1048

What is the recovery model? List the types of recovery model available in sql server?

884

Suggest a method of joining two tables.

1143

How to find the login name linked to a given user name?

994

Can sql servers link to other servers?

1069