Pair Wise & Non-Pair Wise Columns

What are Pair Wise & Non-Pair Wise Columns?

gvmahesh
Profile Answers by gvmahesh Questions by gvmahesh
Jul 27th, 2009
3
5326

Questions by gvmahesh answers by gvmahesh

SQL

Answer

Showing Answers 1 - 3 of 3 Answers

Vinod Tuteja

Jun 6th, 2013

NON PAIRWISE COMPARISON SUBQUERY:

Code
SELECT employee_id, manager_id, department_id


  FROM employees


 WHERE manager_id IN


            (SELECT manager_id


               FROM employees


              WHERE first_name = John)


   AND department_id IN 


            (SELECT department_id


               FROM employees


              WHERE first_name = John)


   AND first_name != John;

PAIRWISE COMPARISON SUBQUERY:

Code
SELECT employee_id, manager_id, department_id


  FROM employees


 WHERE (manager_id, department_id) IN


              (SELECT manager_id, department_id


                 FROM employees


                WHERE first_name = John)


   AND first_name != John;