重复数据处理
--重复数据只显示一条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的字段
发布时间: 2013-03-01 18:33:02 作者: rapoo
重复数据处理
--重复数据只显示一条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的字段