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
- 16654 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 are built in functions?
Determine when an index is appropriate?
What is a user-defined function in the sql server and what is its advantage?
How to manipulate data from one table to another table ?
What is amo? : sql server analysis services, ssas
How connect excel to sql server?
what is the difference between a primary key and a unique key? : Sql server database administration
How to delete duplicate rows in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How do I schedule a sql server profiler trace?
Explain what is the difference between union and union all?
Explain features of analysis services?
What is 2nf normalization form?
What is the difference between locking and multi-versioning?
how to overcome kernel isssues
