macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Finding Duplicate records

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

<Prev in Thread] Current Thread [Next in Thread>