创建基于行号的列，并对另一列重复

Question

我想根据每个产品ID逐列创建行号，并为另一个产品ID返回1。

包装IDA001P0011A002P001A003P0013A004P002<1>A005P002A006P003<1>A007P004<1>A008P004//tr>

Answer 1

使用ROW_NUMBER窗口函数(请参阅此处和此处(。

select pack_id
, product_id
, row_number() over (partition by product_id
order by pack_id)    "row number"
from test;

演示。