37-SQL-查询报错ORA-00979 不是 GROUP BY 表达式.md

注意

本博文仅供学术研究和交流参考，严禁将其用于商业用途。如因违规使用产生的任何法律问题，使用者需自行负责。

如下所示为我的SQL查询报错

complete! use time:151	end time Tue Jun 23 14:29:39 CST 2020null
Caused exception message is: ORA-00979: 不是 GROUP BY 表达式

SQL查询语句如下所示

SELECT
 "T_FIN_LoanEntry".FAmount AS "FAmount",
 "T_FIN_Loan".FTypeID AS "FTypeID",
 "T_FIN_FinancingProducts".FID AS "FID",
 "T_FIN_FinancingProducts".FName_l2 AS "FName",
 "T_FIN_Loan".FCompanyID AS "FCompanyID"
FROM
 T_FIN_FinancingProducts AS "T_FIN_FinancingProducts" INNER JOIN (T_FIN_LoanEntry AS "T_FIN_LoanEntry" INNER JOIN T_FIN_Loan AS "T_FIN_Loan" ON ("T_FIN_LoanEntry".FParentId="T_FIN_Loan".FID))
 ON ("T_FIN_FinancingProducts".FID="T_FIN_Loan".FTypeID)
where  "T_FIN_FinancingProducts".FID in ('umYAAABTeAbCXtep','umYAAAABNRrCXtep')
GROUP BY "T_FIN_Loan".FCompanyID

将其更改为如下SQL语句则可解决报错

SELECT
 "T_FIN_LoanEntry".FAmount AS "FAmount",
 "T_FIN_Loan".FTypeID AS "FTypeID",
 "T_FIN_FinancingProducts".FID AS "FID",
 "T_FIN_FinancingProducts".FName_l2 AS "FName",
 "T_FIN_Loan".FCompanyID AS "FCompanyID"
FROM
 T_FIN_FinancingProducts AS "T_FIN_FinancingProducts" INNER JOIN (T_FIN_LoanEntry AS "T_FIN_LoanEntry" INNER JOIN T_FIN_Loan AS "T_FIN_Loan" ON ("T_FIN_LoanEntry".FParentId="T_FIN_Loan".FID))
 ON ("T_FIN_FinancingProducts".FID="T_FIN_Loan".FTypeID)
where  "T_FIN_FinancingProducts".FID in ('umYAAABTeAbCXtep','umYAAAABNRrCXtep')
GROUP BY "T_FIN_Loan".FCompanyID

---

分割线

---

相关信息

以上就是我关于 SQL-查询报错ORA-00979 不是 GROUP BY 表达式 知识点的整理与总结的全部内容，希望对你有帮助。。。。。。。