Collections:
Group Functions Used with Non-group Selection Fields in Oracle
Can Group Functions Be Mixed with Non-group Selection Fields in Oracle?
✍: FYIcenter.com
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
2019-11-21, 1642🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...