means that there's at least one id/something that will help you know that
the record is a duplicate. An example of this sql is:
select emp_ID, departmentid
from employees
GROUP BY emp_ID, departmentid
having count(emp_ID)>=2
I had to do this for a database that I took over and didn't feel comfortable
deleting any record until I knew that the one of them was verified as
correct.
J
-----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]
