Sharon, Select idcolumn, count (*) from tablename + group by idcolumn + having count (*) > 1
Bill On Tue, 15 Oct 2002 13:12:04 -0400, Sharon Lima wrote: >For example, I have 25000 rows of data and in a few cases an id# has been incorrectly used in more that one record. This happened before a rule was in place but now I want to find the duplicated id#s so pre- existing data will not be in violation of the rule. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
