数据集:
按照id和name分组排序(去重):
select
a.id,
a.name,
a.address,
a.row_number
from
(
select
*,
row_number() over (partition by id,name order by name desc) as row_number
from
dmp_dws_prd.test
) a;
查询结果如下:
最终结果:
数据集:
按照id和name分组排序(去重):
select
a.id,
a.name,
a.address,
a.row_number
from
(
select
*,
row_number() over (partition by id,name order by name desc) as row_number
from
dmp_dws_prd.test
) a;
查询结果如下:
最终结果: