Actually the first step makes sure that the temptable only have one record per corresponding duplicate records. This is achieved by the "group by" clause. This is grouped by...

Step1: You need to create a table containing only the duplicate records by first selecting all the duplicate records into a new table i.e.

Insert into temptable (Select...