Microsoft KB Archive/118294

= How To Create a List of Duplicate Records =

Article ID: 118294

Article Last Modified on 12/1/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.6 for MS-DOS
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.6 Standard Edition
 * Microsoft FoxPro 2.5b for Macintosh
 * Microsoft Visual FoxPro 2.5c for Macintosh

-



This article was previously published under Q118294



SUMMARY
This article shows how to generate a list of duplicate records in a database so that you can visually determine what records need to be deleted.



MORE INFORMATION
The following code generates a full list of the duplicate records in INVOICES.DBF and places the list in a cursor named XXX: USE \tutorial\invoices SELECT * FROM invoices WHERE cno IN ; (SELECT cno FROM invoices GROUP BY cno HAVING COUNT(cno) > 1) ; ORDER BY cno ; INTO CURSOR xxx

Additional query words: VFoxWin FoxMac FoxDos FoxWin identical exact same having clause

Keywords: KB118294

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.