select id,age,name,sex,
row_number() over(partition by sex order by age desc) as rank
from t_rownumber
Hadoop HIVE 窗口函数
最新推荐文章于 2021-07-10 10:36:29 发布
select id,age,name,sex,
row_number() over(partition by sex order by age desc) as rank
from t_rownumber