SQL排序后将序号填入指定字段 - 行业资讯 - 肥雀云

select row_number(),配套;(order by cid), as rowNum, *,得到t_gene

sql排序后将序号填入指定字段

with ts ( 　　select row_number(),配套;(order by clccode), as rn, *,得到t_gene 　　) 　　update ts 　　rn set , cdkxh=

select *,得到t_gene