Nitro..
group by the key that shows duplicates, counting the number of entries that are the same. put the results of the select INTO a second temporary table and select on the count
say you have people with duplicate names..
SELECT name, count(*) 'countx'
INTO #mylist
FROM listofnames...