ROW_NUMBER() OVER (PARTITION BY batchno,txndate ORDER BY qty DESC) AS rn
SQL去重排序分组
最新推荐文章于 2024-06-13 09:00:30 发布
ROW_NUMBER() OVER (PARTITION BY batchno,txndate ORDER BY qty DESC) AS rn