Oracle - What Are Group Functions in Oracle

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.

⇒Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 220👍, 0💬

Popular Posts:

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...

GO - Sending a State...

How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...