常用SQL

1、按字段删除重复数据，只保留一条

delete from table_name a
where a.rowid <>(select max(b.rowid) fromtable_name  b where b.name = a.name and b.kecheng = a.kecheng and b.score = a.score);