Interested to Buy Any Domain ? << Click Here >> for more details...
what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 23777 Views
- Patni, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Define Unique Key?
Difference between report and query parameter. Why do we need different type of parameter?
What are the 2 types of classifications of constraints in the sql server?
What are the advantages of using third-party tools?
Do you know what are different types of replication in sql server?
Can we use trigger new in before insert?
What is difference between inner join and full join?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What do you understand by mirroring?
What are different backups available in sql server?
List the different types of joins?
What is a transact-sql statement batch in ms sql server?
What is the difference between varchar and varchar types?
What is self contained scalar sub query?
How you can change the database name in SQL SERVER?
