--通过开窗函数获取每个组合最新的记录select datetime，stationid，itemid，value from (select datetime，stationid，itemid，value ,row_number() partition by (stationid，itemid order by datetime desc) as flag from 表名) a where flag = 1
