delete from ucs_projectno_pms
where uniqueid in (select uniqueid from ucs_projectno_pms group by uniqueid having count(uniqueid) > 1)
and rowid not in (select min(rowid) from ucs_projectno_pms group by uniqueid having count(uniqueid )>1)
where uniqueid in (select uniqueid from ucs_projectno_pms group by uniqueid having count(uniqueid) > 1)
and rowid not in (select min(rowid) from ucs_projectno_pms group by uniqueid having count(uniqueid )>1)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
