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;