Use the groupby and having count functions. Thanks Matt -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Casey Crookston Sent: Monday, August 21, 2006 9:14 AM To: thelist at lists.evolt.org Subject: [thelist] MS SQL 2000 Is it possible to run a query that would return all rows that are exact duplicates except for the unique identifier? Thanks, Casey -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !