search for recurring names

[lipo]

I have to search for possible recurring names in a table with about 6000 records. How do I make a temp file with just the few names that recurred more than once? I indexed on lastname, but then I would have to manually check for repeat occurrence for each name and the table has too many records.

 

[baltman]

Select NAME,sum(1) as Ncnt group by Name having NCnt>1

Brian

 

[baltman]

Also, don't forget the 'FROM mytable' clause like I just did

Brian

 

[lipo]

Could someone write more specific code?

 

[Mike Gagnon]

lipo

Could someone write more specific code?

I think Brian's suggestion is as specific as the amount of information you supplied. Anymore specific, we would know the actual name of the table and the actual name of the fields in the table. Which you did not provide.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Lipo,

Could someone write more specific code?

It's difficult to see how we can be more specific than Brian's example. However ....

Assuming your table is called BigTable, and the field holding the name is called Name, the following code will give you a browse window showing all names that occur more than once. This is Brian's code, so give him the credit for it.

Select NAME, sum(1) as Ncnt from BigTable group by Name having NCnt>1

Mike





Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com