17,086
社区成员
发帖
与我相关
我的任务
分享
select c.card_id, c.upload_time
from (select t.*,
--降序 max最先
row_number() over(partition by t.card_id order by t.upload_time desc) rn
from CHRDATAUPLOAD t) c
where rn = 1;