使用Row_Number()取出第一条数据
2017-04-18 本文已影响0人
Asa_Guo
(SELECT *
FROM (SELECT ROW_NUMBER() OVER (PARTITION BY MachineId ORDER BY ReportDateTime DESC) RowNum,
dbo.MachineFault.*
FROM dbo.MachineFault )
AS t1
WHERE RowNum = 1 )
AS ReportTable
