SQL SERVER查询每组最后一条数据

现有表如下：

 

 需要查询每一个item对应的最后一条数据，SQL SERVER 如下：

   SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY ItemCode ORDER BY RecordID desc) as RowNum, * from RSItemCostChange ) as H where H.RowNum = 1 ORDER BY ItemCode