As DBA rebuilt index, it produced error report as following:
Based on the NIGT021 schema, it only has one primary key. Therefore, it may has abnormal and duplicate data in NIGT021.
1. Figure out abnormal data
2. Delete abnormal data
3. rebuild index
Here is the SQL statement template to find duplicate value in this table
Here is an example to apply to NIGT021