delete from 资产佛山未对应上人员ok1 where 用户id in
(select 用户id from 资产佛山未对应上人员ok1 group by 用户id having count(用户id) > 1)
and rowid not in (select min(rowid) from 资产佛山未对应上人员ok1 group by 用户id having count(用户id )>1)
- 今日
- 1
- 今月
- 472
delete from 资产佛山未对应上人员ok1 where 用户id in
(select 用户id from 资产佛山未对应上人员ok1 group by 用户id having count(用户id) > 1)
and rowid not in (select min(rowid) from 资产佛山未对应上人员ok1 group by 用户id having count(用户id )>1)
查看Linux启动日志：
...
热搜榜
上海网站建设
赵姐商业
Donaldfef
MERGEL44
手赚术
游客0519
Miss Hu
Larryruita
亲，沙发正空着，还不快来抢？
我要评论 / 展开表单