使用max获取到最大Id然后再从Id里获取到对应的数据
select * from [TreeData_History] where id in ( SELECT MAX(Id) as MId
FROM [jy_rdc].[dbo].[TreeData_History] group by Node_ID ) order by LOCAL_DATE desc
使用max获取到最大Id然后再从Id里获取到对应的数据
select * from [TreeData_History] where id in ( SELECT MAX(Id) as MId
FROM [jy_rdc].[dbo].[TreeData_History] group by Node_ID ) order by LOCAL_DATE desc