What Are Group Functions in Oracle

Q

What Are Group Functions in Oracle?

✍: FYIcenter.com

A

Group functions are functions applied to a group of rows. Examples of group functions are:

  • COUNT(*) - Returns the number of rows in the group.
  • MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group.
  • MAX(exp) - Returns the maximum value of the expression evaluated on each row of the group.
  • AVG(exp) - Returns the average value of the expression evaluated on each row of the group.

 

Use Group Functions in the SELECT Clause in Oracle

Filter Out Duplications in Returning Rows in Oracle

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-12-19, 1505🔥, 0💬