JZTXT

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

发布时间 2023-04-07 11:52:51作者: 明天星期五啦

现有表如下：

 

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

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