select * from 表 a where exists(select * from (select 测站名称,max(时间) as FTime from 表 group by 测站名称) xwhere x.测站名称=a.测站名称 and a.时间=x.FTime )