Pair and Non Pair Wise Comparison

What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?

Questions by svp.kiran

Showing Answers 1 - 1 of 1 Answers

todeepakmalhotra

  • Sep 30th, 2008
 

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 within a single query, whereas in the second one we are checking each column individually with two queries.

So the output will also differes, check it out by practical implementation.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions