Lena,
select count(itemu) into vu from spxn where itemu in (select itemu from spxn group by itemu having count(itemu)>1) did the trick. Thanks to all for your help. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Lena Dammstrom Sent: Thursday, 23 April 2015 12:42 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Detecting duplicate values in a table 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]> [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
