Oracle如何分组排序并产生序号
分组序号
select row_number() over(partition by a.storerkey,a.sku order by a.storerkey,a.sku,a.adddate) cno,a.sku,a.adddate from itrn a
order by a.storerkey,a.sku,a.adddate
select row_number() over(partition by a.storerkey,a.sku order by a.storerkey,a.sku,a.adddate) cno,a.sku,a.adddate from itrn a
order by a.storerkey,a.sku,a.adddate