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, 1728🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...