Collections:
Use Group Functions in the SELECT Clause in Oracle
How To Use Group Functions in the SELECT Clause in Oracle?
✍: FYIcenter.com
If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query. The following select statement returns 4 values calculate by 4 group functions on all rows of the "departments" table:
SQL> SELECT COUNT(*), MIN(department_id), 2 MAX(department_id) FROM departments; COUNT(*) MIN(DEPARTMENT_ID) MAX(DEPARTMENT_ID) ---------- ------------------ ------------------ 27 10 270
⇒ Group Functions Used with Non-group Selection Fields in Oracle
⇐ What Are Group Functions in Oracle
2019-11-21, 1598🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...