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