RE: SQL for duplicate entries

[DURETTE, STEVEN J (AIT)]

You could do something like


select myField, count(myField)
from myTable
group by myField


to get a list of your key item and how many there are.


For just the ones that are duplicates try:


select myField, count(myField)
from myTable
group by myField
having count(myField) > 1


Steve

-----Original Message-----
From: brob [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 3:09 PM
To: CF-Talk
Subject: SQL for duplicate entries

Hey guys, i have a table with abot 4,000 records.  Is there a special SQL
that will return all records that are duplicates, or do I have to do it the
old fashioned way?

THanks
  _____  

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---