HIVE中
select * from
(SELECT user_id ,
pay_time amont,
Row_Number() OVER (partition by user_id ORDER BY pay_time ) as rank
FROM employee
)as t
where rank=3
双十一第3笔订单
最新推荐文章于 2022-11-09 16:51:44 发布
HIVE中
select * from
(SELECT user_id ,
pay_time amont,
Row_Number() OVER (partition by user_id ORDER BY pay_time ) as rank
FROM employee
)as t
where rank=3