为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：udpate 后面加上order by 报错
update hr.emp set order_num = rownum
order by ifnull(order_num,‘99999’) asc, created_date asc
回答 0
暂无回答
myth8860
–update后面不能直接接order by，可以试试分析函数，例如：
update emp t set order_num =
(
select rn
from (select order_num,row_number() over(order by ifnull(order_num,‘99999’) asc, created_date asc) rn
from emp t1
) t1
where t.order_num = t1.order_num
)
–update后面不能直接接order by，可以试试分析函数，例如：
update emp t set order_num =
(
select rn
from (select order_num,row_number() over(order by ifnull(order_num,‘99999’) asc, created_date asc) rn
from emp t1
) t1
where t.order_num = t1.order_num
)