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
- 16837 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
Describe in brief authentication modes in sql server.
How to manipulate data from one table to another table ?
Why truncate is ddl?
How to update values in a table with update statements in ms sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is a collation in ms sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
What is the cartesian product of the table?
explain declarative management framework (dmf) in sql server 2008?
What are trace files?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain why variables called the most powerful component of ssis?
How to create a store procedure with encryption?
How to specify the collation for a character data type in ms sql server?
What are built in functions?
