select t.order_no, t.created_time, t.source_type
from (select o.order_no,
o.source_type,
o.created_time,
row_number() over(partition by o.source_type order by o.created_time desc) rw
from Mi_cod_mall_order o) t
where t.rw = 1
and t.source_type is not null
Row_Number() OVER 根据时间取最新数据
最新推荐文章于 2022-12-01 16:24:14 发布