delete from student s1 where s1.rowid in (
select s1.rowid
from student s2
where
s2.sid=s1.sid and
s2.sname=s1.sname and
s2.sex = s1.sex and
s2.address = s1.address and
s2.tid =s1.tid and
s2.rowid>s1.rowid
)
数据库删除重复数据
最新推荐文章于 2020-10-20 15:04:12 发布