
December 5th, 2012, 08:01 AM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 3
Time spent in forums: 1 h 27 m 45 sec
Reputation Power: 0
|
|
|
Finding rows with duplicate data?
Any help or direction would be appreciated not sure exactly where to start.
I have one table 5 columns, ID is the primary key and the 4 additional columns are text fields.
e.g.
ID A B C D
1 1 2 1 2
2 1 2 1 2
3 1 2 1 2
4 1 2 1 2
5 4 3 2 1
6 4 3 2 1
7 3 2 1 1
When columns A, B, C, D all match for four or more rows (ID’s) I would like to return those ID’s
In the above example I would like the query to return ID = 1,2,3,4. As those ID's all have A=1, B=2, C=1 and D-2.
Note Columns A, B, C, D are text fields and there will be multiple IDs that need to be returned with different values in columns A, B, C, D, I dont want to search for A=x, B=y etc.
Thank you in advance for your assistance.
|