Susan,
Try this
Select Columns: NAME, Count(*)
>From Tables: YourTable
Group By: NAME
Sort By: 2 Desc
That will give you a unique list of all the names in your table, sorted by
the second column (Count) so that those with duplicate entries will show up
first.
Hope it helps,
Jeff James
Vice President
Sage Software, Inc.
3423 Piedmont Road NE
Suite 500
Atlanta, Georgia 30305
www.sagesoft.com <http://www.sagesoft.com>
Phone: 404.262.7478.x12
Fax: 404.832.3366
eFax: 520.222.2020
-----Original Message-----
From: Smith, Susan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 4:34 PM
To: [EMAIL PROTECTED]
Subject: MI query one column
Does any one know how to structure a query so that values in one column can
be compared against one another?
For Example:
NAME
Smith
Jones
Miller
Jones
Washington
Jefferson
I then want to know that Jones was entered twice.
thanks ahead of time.
susan smith
----------------------------------------------------------------------------
----------------------------------------------------------------------------
---
Susan A. Smith
GIS Coordinator
County of Schuylkill
401 North Second Street
Pottsville, PA 17901
phone 570.628.1038
fax 570.628.1005
e-mail [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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
