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, 1520🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...