View previous topic :: View next topic
|
Author |
Message |
rajesh_manas
New User
Joined: 30 Mar 2006 Posts: 11
|
|
|
|
Dear All,
I have to select some combination of rows from the table as follows
Lets say, Column A is of Char(6) and Column B is of Char(12) in a table TAB1.
The records in the table is as follows..
Table : TAB1
A B
- -
102345 123456789100
102345 123456789100
102345 123456789101
102345 123456789101
102321 123456789123
102322 123456789124
102343 123456789125
102344 123456789126
102344 123456789127
102347 123456789128
From the above table, I need the list of rows where Column A is having more than one unique column B value
I mean the query should result as below
Output:
102345 123456789100
102345 123456789100
102345 123456789101
102345 123456789101
102344 123456789126
102344 123456789127
Since 102345 and 102344 has more than one unique value in Column B.
Please kindly let me know the query if available.
Thanks in advance
Regards.
Rajesh |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Code: |
SELECT A, B
FROM DB2.TAB1 TT1
WHERE EXISTS
(SELECT COUNT(DISTINCT B)
FROM DB2.TAB1 TT2
WHERE TT2.A = TT1.A
HAVING COUNT(DISTINCT B) > 1
)
;
|
|
|
Back to top |
|
|
|