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
- 24396 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 sql server be linked with other servers like oracle?
When would you use a before or after trigger?
What are the properties of the transaction?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
State a few properties of relational databases?
Explain the truncate command? : SQL Server Architecture
What is check constraint in sql server?
How many types of functions are there in sql server?
What is the use of @@spid?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Explain the architecture of ms sql reporting service?
What do you mean by data integrity?
Explain what is “asynchronous” communication in sql server service broker?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What are different backups available in sql server?
