I do it in two steps
SELECT ssn, COUNT(*) as countssn ;
FROM sometabl ;
GROUP BY ssn ;
INTO CURSOR dupessns

SELECT custname, amt, ssn ;
FROM sometabl ;
WHERE ssn IN (SELECT ssn from dupessns) ;
ORDER BY ssn

>Thanks, that returned a count of how many. I don't suppose there is a way to list those returned rows with name and amt along with the found duplicate ssn?
>
>Thanks
>Nick Patel