方法一:
delete
from pornpages t1
where t1.rowid>(select min(t2.rowid) from pornpages t2 where t1.recordid=t2.recordid)
方法二:
delete
from pornpages
where rowid not in(select min(rowid) from pornpages group by recordid)
推荐方法一
方法一:
delete
from pornpages t1
where t1.rowid>(select min(t2.rowid) from pornpages t2 where t1.recordid=t2.recordid)
方法二:
delete
from pornpages
where rowid not in(select min(rowid) from pornpages group by recordid)
推荐方法一