macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]
<prev [Date] next>
<prev [Thread] next>

Re: Finding Duplicate records

from [cf_dev2]
Subject: Re: Finding Duplicate records
From: "cf_dev2"
Date: Tue, 10 Jul 2007 20:26:21 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion 

Or if its the same table, just

SELECT ThePrimaryKey, count(*)
FROM   YourTable
GROUP BY ThePrimaryKey
HAVING COUNT(*) > 1
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: Finding Duplicate records, paross1
Next by Date:  Re: Finding Duplicate records, liquid One
Previous by Thread:  Re: Finding Duplicate records, paross1
Next by Thread:  Re: Finding Duplicate records, Dan Bracuk
Indexes:  [Date] [Thread] [Top] [All Lists]