11 ORA系列：ORA-01791: 不是 SELECTed 表达式（distinct使用注意点）

最新推荐文章于 2023-03-28 11:07:40 发布

Java仗剑走天涯

最新推荐文章于 2023-03-28 11:07:40 发布

阅读量2.8w

点赞数 7

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： Oracle distinct ORA-01791 distinct使用

本文链接：https://blog.youkuaiyun.com/baidu_37107022/article/details/78358143

not a Selected expression:不是一个查询表达式；

原始报错sql：

select
distinct
            report.fid as "reportId",
           -- assign.fassigntype as "type",
            report.fsalestatus as "saleStatus",
            report.ftransactionstatus as "transactionStatus",
            report.fsettleaccountstatus as "settleAccountStatus",
            report.ftenementdetail as "tenementDetail",
            person.fid as "personId",
            person.fname as "personName",
            -- 上数业绩，分成比例
            (select sum(assign.fprice) || '| ' || sum(assign.fproportion)
            from t_trade_commissionassign assign
            where report.fid = assign.fktransactionreportid
            and assign.fkpersonid = person.fid
            ) as "ppsum",
            to_char(report.ftransactiondate,'yyyy-MM-dd') as "transactio