MySQL使用group by分组查询每组最新的一笔数据

     select
    t.*,PAL_ECO_ENV_QUAL_AIMS_WTR_QUAL_INFO.STN_NM AS stnCdName
from
    (
select
        stn_cd,
        max(data_tm) as date_time
    from
        dw_eco_env_qual_atm_orig_day_rgn_hist_dtl
    group by
        stn_cd ) a
left join dw_eco_env_qual_atm_orig_day_rgn_hist_dtl t
left join PAL_ECO_ENV_QUAL_AIMS_WTR_QUAL_INFO on t.stn_cd=PAL_ECO_ENV_QUAL_AIMS_WTR_QUAL_INFO.STN_CD
on
    t.stn_cd = a.stn_cd
    and t.data_tm = a.date_time;

如果是时间最大值，里面的是字符串格式的应该要转换一下

select

pointcode,

max(cast(time as datetime)) as time

from

rel_eco_env_qual_dust_hour_mon_data

group by

pointcode

相关链接：https://www.cnblogs.com/lingyejun/p/16728418.html