Hi, select * from EMP where null=null; ->null=null is always false s

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

Question Posted / sailaja

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

Answer Posted / sailaja

Hi,

select * from EMP where null=null;
->null=null is always false so it gives 0 records.
if it is null is null then it fetches all the records in a
table..

select * from EMP where 1=1;
->it fetches all the records in a table
if it is select * from EMP where 1=2;
-->it fetches 0 records..

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain can you implement data mining in ssrs?

161

What is primary key, unique key, and foreign key?

1026

What is your recommendation for a query running very slow? : sql server database administration

1120

Explain transaction server distributed transaction?

1042

What is the correct order of the logical query processing phases?

1002

What are different types of table joins?

1063

What is the report builder?

145

What stored by the master?

1020

Tell me what is log shipping?

1039

Explain encryption of entire databases without the need for application changes in sql server 2008?

1092

What sql server means?

1014

How to stop a loop early with break statements in ms sql server?

1077

What is tempdb database? : SQL Server Architecture

1269

What is #table in sql server?

1109

How to create a dml trigger using create trigger statements?

1102