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
- 24917 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
What is the difference between delete and truncate statements?
how to invoke a trigger on demand? : Sql server database administration
Difference between group by clause and having clause in SQL?
What are the three different part of rdl file explain them?
What is implicit cursors?
How will you monitor replication latency in transactional replication? : sql server replication
What are the restrictions that views have to follow?
What is the difference between NOROW and LOCKROW?
Explain the different types of backups available in sql server? : sql server database administration
What are different types of database indexes?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to check if a table is being used in sql server?
How to name query output columns in ms sql server?
Is oracle faster than sql server?
What are scheduled tasks in sql server?
