删除重复选课数据

2020-05-07 0 条评论 32 次阅读 0 人点赞

select count(a.xs0101id), to_char(wm_concat(distinct a.xs0101id)),to_char(wm_concat(a.jx0404id))
from jx0501 a
where a.xnxq01id = '2017-2018-2'
group by a.jx0404id, a.xnxq01id, a.xs0101id
having count(a.xs0101id) > 1;

select * from jx0501 a where a.xs0101id='XS2016002715' and a.xnxq01id='2017-2018-2' and jx0404id='201720182005606'

select * from xs0101 where xs0101id='XS2016002715'

delete from jx0501 where jx0501id='9F348B19EB3E4282AC13E99071D9EE91'

root

这个人太懒什么东西都没留下

文章评论(0)