sankar.nandakumaran (3/15/2013)

---

Hi......

I have one table in my database say for example "TableA" and the data is shown below..

ID Value

1 A (common for all ids)

1 B (common for all ids)

2 A (common for all ids)

2 C

2 B (common for all ids)

3 A (common for all ids)

3 B (common for all ids)

3 C

3 D

My problem is i need two sql queries which will give the following two resultant sets as shown below

First sql query result will be like this Common Factors in ID (1,2,3)

A

B

Second query result will be Common Factors in ID (1,2,3)

C (here c is not in id 1 so will be listed here)

D

Can any one please give the two queries please , just i need common factors in one set and uncommon factors in another set ..I need two SQL queries but

Thanks and Regards

Sankar