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

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)