Select * from ( SELECT A.Name, B.*, row = ROW_NUMBER() OVER(PARTITION BY A.StuId ORDER BY B.SubmitTime DESC) FROM A JOIN B ON A.StuId = B.StuId ) AS t WHERE t.row = 1
表A与表B是一结多的关系,取表B中最近的一条记录
分组统计,取排名为1的数据
Select * from ( SELECT A.Name, B.*, row = ROW_NUMBER() OVER(PARTITION BY A.StuId ORDER BY B.SubmitTime DESC) FROM A JOIN B ON A.StuId = B.StuId ) AS t WHERE t.row = 1
表A与表B是一结多的关系,取表B中最近的一条记录
分组统计,取排名为1的数据
转载于:https://www.cnblogs.com/gxivwshjj/p/8616512.html