How To Create a List of Duplicate Records (118294)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft FoxPro for MS-DOS 2.0
  • Microsoft FoxPro for MS-DOS 2.5
  • Microsoft FoxPro for MS-DOS 2.5a
  • Microsoft FoxPro for MS-DOS 2.5b
  • Microsoft FoxPro for MS-DOS 2.6
  • Microsoft FoxPro for Windows 2.5
  • Microsoft FoxPro for Windows 2.5a
  • Microsoft FoxPro for Windows 2.5b
  • Microsoft FoxPro for Windows 2.6
  • Microsoft FoxPro for Macintosh 2.5b
  • Microsoft FoxPro for Macintosh 2.5c
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 <FoxPro_directory>\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
Modification Type:MajorLast Reviewed:12/1/2003
Keywords:KB118294
©2003 Microsoft Corporation. All rights reserved.