重复数据处理--重复数据只显示一条select min(a) a, b, c from test_tb group by b, c--删除重复数据dele
重复数据处理 --重复数据只显示一条select min(a) a, b, c from test_tb group by b, c;--删除重复数据delete from tb where rowid not in (select min(rowid) from test_tb group by b, c);group by 查询列只能用聚集函数或被group by的字段
