SQL自增序列 Alec

select row_number() over (order by PKID)as ID,PKID,TypeName,IsReward,Remark,createtime,Person,Reason,Content,Recorder from hr_rewardpunish