You could do a Select FieldName, Count(*) from TableName Group By FieldName having count(*) > 1
This would give you a list of duplicates Regards Lena From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty Sent: Wednesday, April 22, 2015 7:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Detecting duplicate values in a table I would appreciate some advice on how to detect duplicate values for a column in a table. Apart from using a cursor to go through each row and then looking for rows with the same value is there any quicker way of doing this ? Any suggestions would be appreciated. Thank you. Regards, John Docherty
