mysql - 如何根据总收入（net_ph）获得排名？

Question

上图是我想要的输出，我希望它具有基于“净收入总和（net_ph）”的排名

我的 PHP 代码

SELECT artist, label, SUM(net_ph) as net_ph from believe_tb where  accounts_of='$cid2' group by artist, label

查询输出（无排名）

标签： mysqlsql

Answer 1

您可以使用如下查询：

select artist, label,
       RANK() OVER (ORDER BY SUM(net_ph) desc) as ranking,
       SUM(net_ph) as net_ph
from believe_tb
group by artist, label; 

希望这可以帮助。更多关于 RANK() 函数：https ://www.mysqltutorial.org/mysql-window-functions/mysql-rank-function/