what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 21458 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
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How can sql injection be stopped? : sql server security
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is the fastest way to permanently delete a 1 million row table named customers?
When a primary key constraint is included in a table, what other constraints does this imply?
What is the purpose of object explorer and its features? : sql server management studio
What is the definition for sql server 2000?
What are four major operators that can be used to combine conditions on a where clause?
Can you name a few encryption mechanisms in sql server?
What is indexing in sql server with example?
Explain SSRS Architecture?
Why use identity in sql server?
What is the difference between seek predicate and predicate?
What are the lambda triggers?
Explain important index characteristics?
