what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
- 2 Answers
- 16139 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 the difference between primary key and unique key? : sql server database administration
How to rebuild the master database?
How can windows applications connect to sql servers via odbc?
Difference between 2NF &3NF ?
How to enable tcp/ip protocol on a sql server?
What is function of ROLLUP ?
Can we use where clause with group by?
How do I get to sql server configuration manager?
What is a trigger and types of a trigger?
How to specify the collation for a character data type in ms sql server?
what is normalization? : Sql server database administration
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What's the information that can be stored inside a bit column?
What is report snapshot in ssrs?
How many null values we can have in a unique key field in sql server?
