Try something like this (substitute the field for the actual field name that you want to check for duplicates on):

SELECT field,COUNT(DUNSNum) AS dupcount ;
FROM table ;
GROUP BY field;
HAVING dupcount>1 ;
INTO CURSOR c_dupes