Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
- 2 Answers
- 16944 Views
- I also Faced
- E-Mail Answers
Answer Posted / taroon
See the thing is in pairwise comparison, we are taking the
columns which are of composite key type, so that the
comparisons will be very effective. But nonpairwise
comparisons are like multi_row subqueries with IN operator,
where we are checking single column values.
But the results will be different in both the cases. Just
try. If you want some examples regarding that, just do let
me know.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the difference between a view and a stored procedure?
What are click through reports?
What is difference between joins and subqueries?
Tell me what is fill factor?
What is transaction server explicit transaction?
What is reference section?
What is the difference between clustered and non-clustered indexes in ms sql server?
Explain how to use linked server?
How do indexes help, types?
What is normalization of database? What are its benefits?
Do you know what is similarity and difference between truncate and delete in sql?
What is an entity-relationship diagram (erd)?
What is the difference between set and select?
Why use identity in sql server?
What is optimistic concurrency?
