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.

how to find the second salary?

10 Answers   HCL, Prithvi,

---

Explain the difference between cross join and full outer join?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

---

What does man by sql wildcard characters in sql server?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

How to execute stored procedure in select statement sql server?

0 Answers  

---

What is the difference between an index and a unique index?

0 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

How do you know which index a table is using?

4 Answers  

---