Reply To: How to remove duplicate rows? Stephen West ~ Modified: November 19th, 2015 ~ ~ 1 Minute Reading Home › Forums › How to remove duplicate rows? › Reply To: How to remove duplicate rows? November 19, 2015 at 12:26 pm #905 Score: 0 Stephen WestModerator Karma: 4 pts 1. SELECT the DISTINCT records into a New Table 2. TRUNCATE the Old Table 3. MERGE the New Table back into the Old Table Search