1、按字段删除重复数据,只保留一条
delete from table_name a
where a.rowid <>(select max(b.rowid) from table_name b where b.name = a.name and b.kecheng = a.kecheng and b.score = a.score);
1、按字段删除重复数据,只保留一条
delete from table_name a
where a.rowid <>(select max(b.rowid) from table_name b where b.name = a.name and b.kecheng = a.kecheng and b.score = a.score);