摘要：
with 月业绩 as (SELECT 年份,月份, ROUND(sum(总业绩)/100000) 业绩 FROM `myj` group by 年份,月份) select * ,ROW_NUMBER() over(PARTITION by 年份 order by 业绩 desc) 'row_N', 阅读全文
posted @ 2022-11-22 14:57 zhuyu123 阅读(25) 评论(0) 推荐(0)
posted @ 2022-11-22 14:57 zhuyu123 阅读(25) 评论(0) 推荐(0)
浙公网安备 33010602011771号