Group Functions Used with Non-group Selection Fields in Oracle

Q

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

✍: FYIcenter.com

A

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.

 

Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 137👍, 0💬