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.

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

What is 1nf 2nf?

0 Answers  

---

Can you leave a union at any time?

0 Answers  

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

Explain syntax for disabling triggers?

0 Answers  

---

what is Archive old data?

1 Answers  

---

Explain intellisense for query editing

0 Answers  

---

List the different index configurations possible for a table?

0 Answers  

---

explain different levels of normalization? : Sql server database administration

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---