-
多条重复字段取单个值
select * from ( select pog.orderno, pog.purchaseprice, pog.institutionno, pog.proxygoodsid, pog.seqno, pog.price_money, row_number() over (partition by pog.orderno order by pog.seqno desc) as group_idx from PROXY_ORDER_GOODSPRICE pog) where group_idx=1 order by orderno asc
【Oracle】数据库相关处理
最新推荐文章于 2024-03-06 10:00:00 发布