17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from qzw;
A B
-------- ----------
甲 5
乙 3
丙 4
甲 2
乙 10
SQL>
SQL> SELECT A, C, ROW_NUMBER() OVER(PARTITION BY MARK ORDER BY C DESC)
2 FROM (SELECT A, SUM(B) C, 'a' MARK FROM QZW GROUP BY A ORDER BY C DESC)
3 ;
A C ROW_NUMBER()OVER(PARTITIONBYMA
-------- ---------- ------------------------------
乙 13 1
甲 7 2
丙 4 3
SQL> drop table qzw;
Table dropped