解决数据重复导致查询出错问题

开发中常常会遇到因为数据存在多条导致查询报错的问题，下面的方法一键解决此问题。

1.查询重复数据条数

select count(1) from tb_jf_order_drawcash 
where order_id in (select order_id
from tb_jf_order_drawcash
group by order_id
having count(order_id) > 1)

2.删除重复数据
delete from tb_jf_order_drawcash
where order_id in (select order_id
from tb_jf_order_drawcash
group by order_id
having count(order_id) > 1)
and ROWID not in (select min(ROWID)
from tb_jf_order_drawcash
group by order_id
having count(*) > 1)