Identify dublicates..? 1

[kenjoswe]

Hi all,

How can I identify all dublicates in a table?
Example:

Field1 Field2 Field3
A B C
A B A
A A A
A B C


Here is the combination A, B, C a dublicate
How can I do this in SQL-syntax?

/Kent J

 

[tlbroadbent]

Select field1, field2, field3
From table
Group By field1, field2, field3
Having count(*)>1
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.