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
- 16812 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 default order of an order by clause?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What are sql servers used for?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What are locks in sql?
What is user defined datatypes and when you should go for them?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How you can get a list of all the table constraints in a database? : Sql server administration
In which sql server version report builder introduced?
What is the difference between deallocate cursor and close cursor?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Tell me what is a linked server?
Explain query editor regions
What is report subscription?
What is the command used to check locks in microsoft sql server?
