Sql语句groupBY分组后取最新一条记录的SQL

Message,EventTime from PT_ChildSysAlarms as a where EventTime = (select max(b.EventTime) from PT_ChildSysAlarms as b where a.PtName = b.PtName ) group by Message,EventTime order by EventTime desc

 

Sql语句groupBY分组后取最新一条记录的SQL

标签：desc   解决方案   语句   最新   event   group   class   color   eve