请教:sql删除重复记录问题?

Question

DELETE a 
FROM 
    textilename a
WHERE 
    EXISTS(SELECT 
               1
           FROM 
               textilename 
           WHERE 
               textilename=a.textilename 
               AND 
               textilekind=a.textilekind 
               AND 
               id>a.id)

Answer 1

DELETE FROM textilename t2
WHERE exists
(SELECT 1 FROM textilename t1
WHERE t1.textilename = t2.textilename AND t1.textilekind = t2.textilekind and t1.id>t2.id)