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 pessimistic lock and optimistic lock?

0 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Define cross join in sql server joins?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What is the maximum length of an alert name?

0 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

What is an execution plan?

0 Answers  

---

What is merge replication?

0 Answers  

---