Can Group Functions Be Mixed with Non-group Selection Fields?
Page 1 of 1
Can Group Functions Be Mixed with Non-group Selection Fields?
by Micheal Sun Jan 17, 2010 3:06 am
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-gorup 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.
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-gorup 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.
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» What Are Group Functions?
» Can Multiple Columns Be Used in GROUP BY?
» Can Group Functions Be Used in the ORDER BY Clause?
» How To Apply Filtering Criteria at Group Level?
» How To Count Groups Returned with the GROUP BY Clause?
» Can Multiple Columns Be Used in GROUP BY?
» Can Group Functions Be Used in the ORDER BY Clause?
» How To Apply Filtering Criteria at Group Level?
» How To Count Groups Returned with the GROUP BY Clause?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL