Help with duplicate records

Results 1 to 2 of 2

Thread: Help with duplicate records

  1. #1
    Chris A. Guest

    Default Help with duplicate records

    I have a question about a recordset I&#039m working with. I have records that all have unique date and time stamps (in separate fields) that will from time to time contain duplicate data in other fields. <BR><BR>I&#039d like to just display the most recent of the "duplicate" records, and ignore the rest (but preserve them in the database--I don&#039t want to delete them). <BR><BR>Is there a way to write such a SQL statement?<BR><BR>Please help...!<BR><BR>= )<BR><BR>C. A.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Try this...

    SELECT max(date_field), dup_field1, dup_field2<BR>FROM mytable<BR>GROUP BY dupfield1, dupfield2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts