what is the difference detween pairwise comparison subquary and non pairwise co

what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?

Question Posted / guest

2 Answers
15718 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?..

Answer / 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

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?..

Answer / 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