17,082
社区成员
发帖
与我相关
我的任务
分享
update org_info set op_type = 1
where rowid in (select recordid from (select rowid recordid,row_number() over(partition by id order by occur_date ASC) RN
from org_info)
where RN = 1 )