select * from (
select t.userid,row_number()over(partition by t.userid order by t.create_time desc) new_index from TSWC_TRADEORDERP2P_BASE t) a where a.new_index = 1
获取分组记录的第一条数据
最新推荐文章于 2022-10-14 09:08:20 发布
select * from (
select t.userid,row_number()over(partition by t.userid order by t.create_time desc) new_index from TSWC_TRADEORDERP2P_BASE t) a where a.new_index = 1