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
- 24200 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
Can binary strings be used in arithmetical operations?
What are sql servers used for?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What are the different index configurations a table can have?
Explain transaction server isolation?
What are the properties of sub-query?
Are semicolons required at the end of sql statements in sql server 2005?
What are trace flags?
Explain transaction server auto commit?
What is difference between foreign key and unique key?
Difference between uniqe index and uniqe constraint?
What happens if null values are involved in comparison operations?
How to fetch the next row from a cursor with a "fetch" statement?
What are various ways to enhance the ssrs report?
What is read uncmmited?
