One way to find the items that are duplicated in a single column in
this:
' This will show all of the items with the duplicates listed first
Select <column>, Count(*) As dupecnt
From <table>
Group by <column> Order by dupecnt Desc
' This will select only those items with duplicates
Select * from Selection Where dupecnt > 1
Browse * from Selection
Ken Fioretti
------------------------------------------------------------------------
----------
Ken Fioretti
Geographic Business Systems
(201) 587-1717
http://www.GeoBusSys.com
------------------------------------------------------------------------
----------
> ----------
> From: Miguel Iturralde[SMTP:[EMAIL PROTECTED]]
> Reply To: Miguel Iturralde
> Sent: Thursday, June 17, 1999 2:26 AM
> To: [EMAIL PROTECTED]
> Subject: MI Finding duplicates
>
> Hello everyone,
> �
> How do I�select duplicate records in a table's column?
> �
> Thanks in advance.
> �
> Miguel Iturralde
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
