Group Functions Used with Non-group Selection Fields in Oracle


Can Group Functions Be Mixed with Non-group Selection Fields in Oracle?



If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of invalid SELECT statements with group and non-group selection fields:

SQL> SELECT COUNT(*), department_id FROM departments;
ORA-00937: not a single-group group function

In this example, COUNT(*) is a group field and department_id is a non-group field.


Divide Query Output into Groups in Oracle

Use Group Functions in the SELECT Clause in Oracle

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-11-21, 1628🔥, 0💬