--重复数据只显示一条
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的字段