谁会吗

你的图发的看不清 ，

select …… from 表名 order by 余额 desc ……省略部份为你的查询列关键字

示例 select name,sal from emp order by sal desc

select rank() over(patition by org_name order by current_bal desc) rank_cd , org_name,cust_id,current_bal from t03_acct_trade_detail

如果明细表中只有客户在银行中最新余额的情况，可以使用下面的SQL:
SELECT RANK () OVER (PARTITION BY org_name ORDER BY current_bal DESC),
cust_id,
org_name,
current_bal
FROM ( SELECT cust_id, org_name, SUM (current_bal) current_bal
FROM t03_acct_trade_detail
GROUP BY cust_id, org_name)