3 Replies Latest reply on Jan 2, 2013 12:32 PM by 982466

    Help: Finding duplicated records

    WJHORA
      I'd like to list record single out the records in a table having these fields to define them as duplicate records.
      ID     CATEGORY     SERVICE_FROM_DATE     SERVICE_TO_DATE
      249407     000055     08/28/1996      08/28/1996 
      249869     000055     08/28/1996      08/28/1996 
      268167     30     07/08/1996      07/25/1996 
      268394     30     07/08/1996      07/25/1996 
      Using group method does not show the list of records. I need the list of records have these fields with duplicated values.

      Any suggestions are greatly appreciated.

      Jimmy