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 ...

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.

System variable and temporary variables

0 Answers   Wipro,

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

Do you know how to store and query spatial data?

0 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

---

How to receive output values from stored procedures?

0 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

What is the difference between migration and upgradation in sql server?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---