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, 2208🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...