select name,count(name) from YourTable group by name having count(name)>1 for i=0 to resultset.recordcount-1 do begin select AnotherColumn,count(AnotherColumn) from YourTable group by AnotherColumn having count(AnotherColumn)>1 ...//do same thing to check more columnsend;
for i=0 to resultset.recordcount-1 do
begin
select AnotherColumn,count(AnotherColumn) from YourTable group by AnotherColumn having count(AnotherColumn)>1
...//do same thing to check more columnsend;