SQL记录 练习题 如图所示,新增一列 (第四列) 答案: select PartNumberID, PartVer, SortSeq, RANK() OVER(PARTITION BY PartNumberID ORDER BY PartVer ) *100 as newSortSeq from PartVersion order by PartNumberID,PartVer