Sql Server 删除重复行

--删除重复行
  SELECT DISTINCT *
      INTO #TEMP
      FROM TFBH
      GROUP BY TFBH,TFM,TFME
      HAVING COUNT(*) > 1

   DELETE TFBH
      WHERE TFBH
      IN (SELECT TFBH
             FROM #TEMP)

   INSERT TFBH
      SELECT *
         FROM #TEMP

   DROP TABLE #TEMP