Group function
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A group function is an Oracle SQL function that returns a single result based on many rows, as opposed to single-row functions. These functions are: AVG, COUNT, MIN, MAX, STDDEV, SUM, VARIANCE, etc.
Examples
SELECT dept, MAX(sal) FROM emp GROUP BY dept;
SELECT MIN(sal), MAX(sal), AVG(sal) FROM emp;
SELECT COUNT(*) FROM emp;
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
