1.单表消除重复行
例如:
删除语句:
delete from teacher where tid not in (select * from (select max(tid) from teacher group by tname having count(tname))as b)
mysql中单表操作
最新推荐文章于 2024-06-25 15:08:30 发布
1.单表消除重复行
例如:
删除语句:
delete from teacher where tid not in (select * from (select max(tid) from teacher group by tname having count(tname))as b)