3 Replies Latest reply: Jan 2, 2013 6:32 AM by 982466 RSS

    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