按照...分组排序后,得到行编号:
row_number() over(partition by ... order by ...)
按照...分组排序后,得到相应的列的第一个数据:
first_value(列名或列位置) over(partition by ... order by ...)
按照...分组排序后,得到行编号:
row_number() over(partition by ... order by ...)
按照...分组排序后,得到相应的列的第一个数据:
first_value(列名或列位置) over(partition by ... order by ...)