>>>I know there was a thread here recently that discussed finding duplicates using SQL... but the UT search seems to be broken, so I'll ask if anyone can provide the thread # or sample code.

I do it like this:

select * from mytable where key in ;
    (select key from mytable group by key having cnt(*) > 1)

This returns a cursor that has all the duplicated records in it.