>>>>>>>>>>>>>>>>>>>> >Try this: > >SELECT * FROM TableName ; > WHERE Name IN (SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > ) ; > INTO TABLE Duplicates >>>>>>>>>>>>>>>>>>>>
Minor typo correction:
SELECT * FROM TableName ; WHERE Name IN ; (SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > 1) ; INTO TABLE Duplicates
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
