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

What are the different types of replication are there in sql server 2000?

568

What are the steps you should follow to start sql server in single-user mode?

490

Explain the collation?

629

What is ssrs?

Can foreign key be deleted?

532

What is the log shipping?

589

Tell me about the approaches which you used to counter the DI problems.

769

What is bcp? When does it use?

515

How many non clustered indexes there can be on table ?

514

What are views used for?

623

What Is Rdbms?

678

Data table as parameter in sql server?

569

What is difference between standardization and normalization?

540

Can multiple columns be used in sql group by clause in ms sql server?

554

plss anybody specify tha constrian management system in dbms

1577