oracle分组序号

来源:互联网 发布:js disabled属性 编辑:程序博客网 时间:2024/06/05 05:36

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

原创粉丝点击