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.

What are various aggregate functions that are available?

0 Answers  

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

---

How to compare the top two records using sql?

0 Answers  

---

Define inner join? Explain with an example?

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---