如何解决“ORA-00979:非按表达式分组”错误
如何解决“ORA-00979:非按表达式分组”错误
提问于 2017-10-18 18:44:54
我正在尝试运行这个查询，我得到的是“不是按表达式分组”
SELECT
PS.SEGMENT1,
PSSI.VENDOR_NAME,
PSSI.VENDOR_SITE_CODE,
AIPA.PAYMENT_NUM,
AIPA.AMOUNT,
AIPA.PAYMENT_CURRENCY_CODE,
AIA.INVOICE_AMOUNT,
AIA.INVOICE_NUM,
AIA.DESCRIPTION,
AIA.INVOICE_DATE
FROM
POZ_SUPPLIERS PS,
POZ_SUPPLIER_SITES_INT PSSI,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_INVOICES_ALL AIA
WHERE PSSI.VENDOR_ID=PS.VENDOR_ID
AND AIA.VENDOR_ID=PS.VENDOR_ID
AND AIPA.INVOICE_ID=AIA.INVOICE_ID
group by AIPA.AMOUNT谁能给我指明正确的方向？
回答 1
Stack Overflow用户
回答已采纳
发布于 2017-10-18 18:57:15
我猜这就是你想要的
SELECT
PS.SEGMENT1,
PSSI.VENDOR_NAME,
PSSI.VENDOR_SITE_CODE,
AIPA.PAYMENT_NUM,
sum(AIPA.AMOUNT) as totalamount,
AIPA.PAYMENT_CURRENCY_CODE,
AIA.INVOICE_AMOUNT,
AIA.INVOICE_NUM,
AIA.DESCRIPTION,
AIA.INVOICE_DATE
FROM
POZ_SUPPLIERS PS,
POZ_SUPPLIER_SITES_INT PSSI,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_INVOICES_ALL AIA
WHERE PSSI.VENDOR_ID=PS.VENDOR_ID
AND AIA.VENDOR_ID=PS.VENDOR_ID
AND AIPA.INVOICE_ID=AIA.INVOICE_ID
group by PS.SEGMENT1,
PSSI.VENDOR_NAME,
PSSI.VENDOR_SITE_CODE,
AIPA.PAYMENT_NUM,
AIPA.PAYMENT_CURRENCY_CODE,
AIA.INVOICE_AMOUNT,
AIA.INVOICE_NUM,
AIA.DESCRIPTION,
AIA.INVOICE_DATE select语句中的sum (金额)将为您完成该总和。然后，您需要按其余的静态列进行分组。
编辑：
我不小心把AIPA.AMOUNT留在了小组里。我修改了答案，确保AIPA.AMOUNT不在你的小组中。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/46817138
复制相关文章
相似问题
腾讯云开发者
