I would think that the "group by Column" function combined with a temporary column created using the aggregate "count(*)" would give you the list that you want"
Jim Henry JCH GeoInfo Solutions Durham, NC > -----Original Message----- > From: Hughes, Colleen / Don Mitchell > [mailto:[EMAIL PROTECTED] > Sent: Monday, September 13, 2004 12:14 PM > To: [EMAIL PROTECTED] > Subject: MI-L Selecting out duplicate values in a TAB > > Hi List, > > This may be rather simple, but I'm having problems figuring > it out. I have a TAB with duplicate Integer values in a > Field, and I need to isolate them. > What would be the SQL to do this. It is probably simple, but > for some reason I can't think of how to do it. I could do a > sorting query, and look for the duplicates, but I have > several thousand records. > > Thanks in advance, > Don Mitchell > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 13286 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13292
