随笔分类 -  sql

摘要：在网上看到不错的 排名语句 select a,sum(b),rank() over(order by sum(b) desc) rnfrom test_06group by a; select a,sum(b),row_number() over(order by sum(b) desc) rn from test_06 group by a rank在出现相同排名时序号是相同的，row_num... 阅读全文