what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
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
how to determine the service pack currently installed on sql server? : Sql server database administration
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is unpivot?
What is normalization of database?
Is mysql the same as sql server?
What is logshipping and its purpose?
How to make a column nullable?
Explain syntax for dropping triggers?
What is primary key and example?
How can you find out which stored procedures are recompiling?
What does Master database contains?
What the different components in replication and what is their use?
How to change a login name in ms sql server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How to override dml statements with triggers?