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
ROW_NUMBER() OVER(PARTTON BY T.ITEM_CODE ORDER BY T.VERSION DESC)
最新推荐文章于 2018-12-19 15:29:45 发布