sql 取出一组中时间最大的一条数据

select * from (select * from attachments order by workorderid,LastUpdated desc) t group by workorderid;