select * from (
select h.commodityid, h.lastpushresult, rank() over (partition by h.commodityid order by h.lastpushtime ) rk
from t_elong_map_rateplan h ) t where t.rk=1;
select * from (
select h.commodityid, h.lastpushresult, rank() over (partition by h.commodityid order by h.lastpushtime ) rk
from t_elong_map_rateplan h ) t where t.rk=1;