套娃的模式,参考如下
select *
from 表
where p_docnum || p_amount in
(select p_docnum || p_amount
from (select p_docnum, max(p_amount) as p_amount
group by p_docnum))
订单号分组 取最大值就可以了啊
https://www.cnblogs.com/wyf-love-dch/p/11159159.html
用窗口函数 row_number排序,取第一条