what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 21461 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / nitin yadav(9229430059)
A. Will give you no record because null have no value that
means no comparision between two nulls.
B.will give all row because 1=1 condision always true for
all rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how you can configure a running aggregate in SSRS?
How many columns can we include on clustered index ?
Define self join?
How to see the event list of an existing trigger using sys.trigger_events?
How do you set a trace flag in sql server?
Difference between Sql server reporting services and Crystal reports?
What do you mean by the term 'normalization'?
What are the advantages of user-defined functions over stored procedures in sql server?
How to use linked server?
what are the disadvantages of cursors? : Sql server database administration
Explain what is meant by replication of database?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Mention the command used to rename the database.
What is the simplest way to create a new database in ms sql server?
What are constraints?
