摘要： with 月业绩 as (SELECT 年份,月份, ROUND(sum(总业绩)/100000) 业绩 FROM `myj` group by 年份,月份) select * ,ROW_NUMBER() over(PARTITION by 年份 order by 业绩 desc) 'row_N', 阅读全文