| |
GeekInterview.com > Interview Questions > Oracle
| Print | |
Question: Pair and Non Pair Wise Comparison
Answer: What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used? |
| September 09, 2008 03:20:40 |
#1 |
| todeepakmalhotra |
Member Since: September 2008 Total Comments: 5 |
RE: Pair and Non Pair Wise Comparison
|
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. |
| |
Back To Question | |
