sql server 分组并取每组的时间最大值
SELECT
TOP 100 PERCENT
a.Device_ID,
a.Device_Code,
b.Device_Name,
MAX (a.StartTime) StartTime
FROM
Test1 a
LEFT JOIN Test2 b ON a.Device_ID = b.
sql server 分组并取每组的时间最大值
SELECT
TOP 100 PERCENT
a.Device_ID,
a.Device_Code,
b.Device_Name,
MAX (a.StartTime) StartTime
FROM
Test1 a
LEFT JOIN Test2 b ON a.Device_ID = b.