Knowledge Hub — Technical Document

Generated on 2026-08-28 06:59 | Confidential Client Asset

Aggregate Functions

Published July 26, 2025 By Sai Sree Ram Gundepudi

Aggregate Functions in Oracle SQL

  • COUNT() – counts rows
  • SUM() – totals a numeric column
  • AVG() – average value
  • MIN() – minimum
  • MAX() – maximum
SELECT COUNT(*) FROM employees;
SELECT MAX(salary), MIN(salary) FROM employees;
SELECT department_id, SUM(salary) FROM employees GROUP BY department_id;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

Aggregate Functions

Using Aggregate Functions in MySQL

ExampleSELECT department_id, AVG(salary) FROM employees GROUP BY department_id;