ROW_NUMBER() OVER(PARTTON BY T.ITEM_CODE ORDER BY T.VERSION DESC)

ROW_NUMBER() OVER(PARTTON BY T.ITEM_CODE ORDER BY T.VERSION DESC)的用法：根据“项目编号”分组，以“版本排序”。如下SQL片段：取项目记录的最高版本。
SELECT *
FROM (SELECT T.ID,
T.WSTYPE_ID,
T.ITEM_CODE,
T.VERSION,
ROW_NUMBER() OVER(PARTITION BY T.ITEM_CODE ORDER BY T.VERSION DESC) RN
FROM TAP_TAS_TLIB_ITEM T
WHERE 1 = 1
AND T.NORMAI_TYPE = 1
–AND T.VERSION > 2
ORDER BY T.ITEM_CODE ASC)
WHERE RN = 1