0 votes
in Oracle by

What is the use of Aggregate functions in Oracle?

2 Answers

0 votes
by

Aggregate function is a function where values of multiple rows or records are joined together to get a single value output. Common aggregate functions are –

  • Average
  • Count
  • Sum
0 votes
by

An aggregate function in Oracle is a function where values of multiple rows or records are joined together to get a single value output. It performs the summary operations on a set of values in order to provide a single value. There are several aggregate functions that you can use in your code to perform calculations.

Some common Aggregate functions are:

  1. Average
  2. Count
  3. Sum

Related questions

0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
0 votes
asked May 11, 2020 in Oracle by JackTerrance
...