错误码 / Oracle Database

Oracle Database 错误码 ORA-00937

not a single-group group function 原因:A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and a…

错误说明

not a single-group group function

原因:A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression was included in a GROUP BY clause.

处理:Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.

官方文档

进一步检索

相关错误码