如何从表中删除重复记录

问题描述

亲爱的所有人，

我想要一个可以删除重复记录的Visual foxpro 9.0中的代码。

I want a code in Visual foxpro 9.0 that can delete duplicate records.

详细

我有一个表名Mymaster。我想删除具有相同Taxapayer和相同Tax_office的记录，如下所示;

I have a table name Mymaster. I want to delete records that have the same Taxapayer and the same Tax_office as shown below;

例如; 2月10月有限公司有相同的tax_office。

for example; 2ND OCTOBER COMPANY LIMITED has the same tax_office.

  纳税人                                                              
Tax_office

 Taxpayer                                                          Tax_office

10月2日COMPANY LIMITED                        Osu

2月十月有限公司                         Osu

A& Ç购物中心                        &NBSP ;                        &NBSP ;          
Tema

A & C Mall                                                             Tema

A& Ç购物中心                        &NBSP ;                        &NBSP ;          
Adenta

A & C Mall                                                             Adenta

Fred Boateng                                                       
Makola

Fred Boateng                                                       
Makola

Gina Owusu                                                         
Nima

Gina Owusu                                                          
Nima

GRA                                                                        
Asokwa

GRA                                                                      Asokwa

GRA                                                                        
Adabraka

GRA                                                                      Adabraka

谢谢

推荐答案

SELECT taxp
INDEX on taxpayer+tax_office tag taxp
SELECT taxpayer,tax_office, SUM(1) as ncount FROM taxp GROUP by taxpayer,tax_office INTO CURSOR c_taxCount
INDEX on taxpayer+tax_office tag taxp

SCAN FOR ncount > 1
  SELECT taxp
  SEEK c_taxCount.taxpayer+c_taxCount.tax_office
  DELETE NEXT c_taxCount.nCount - 1
ENDSCAN

这篇关于如何从表中删除重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！