Group function

From Oracle FAQ
Jump to: navigation, search

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[edit]

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 #