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 many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

How to get nth highest salary from employee table.

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

What is primary key index?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is proper subset of candidate key?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---