3、删除重复数据-轻服务知识库

查询重复数据参照：

SELECT user_id, COUNT(*)

FROM T_LW_TU_MEMBER_INFO

GROUP BY user_id

HAVING COUNT(*) > 1;

删除重复数据参照：

delete from T_LW_TU_MEMBER_INFO where rowid not in (select min(rowid) from T_LW_TU_MEMBER_INFO group by user_id )