delete from yc_tmp_tab_min x
where x.rowid > (select min(rowid)
from yc_tmp_tab_min y
where x.fac_no = y.fac_no
and x.dev_no = y.dev_no
and x.devtype_no = y.devtype_no
and x.dot_no = y.dot_no
and x.savetime = y.savetime);
清除重复记录脚本
最新推荐文章于 2024-05-09 06:15:24 发布