what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
Answer Posted / parnita
In pair wise comparison we write like this:"where (MGR_ID,
DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write
like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN
(SUBQUERY)"In first one we are checking two columns
simultaneously ...
Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What is a database table?
What is 2nf in normalization?
What does man by sql wildcard characters in sql server?
Which are the two editions in which SQL Azure database available?
How do we synchronize On-Premise SQL server with SQL Azure?
Explain index in sql server?
What is left outer join in sql server joins?
What is a non-clustered index?
How to create a simple table to test triggers in ms sql server?
What is the simplest way to create a new database in ms sql server?
What are system databases into sql server (2005/2008)?
What is exporting and importing utility?
explain different types of constraints? : Sql server database administration
Can you explain important index characteristics?
How to find index size for each index on table?