Oracle SQL

What is group function in Oracle SQL?

Group Function in SQL
Written by shohal

Group Function

Group functions are built-in SQL functions that operate on groups of rows and return one value for the entire group. These functions are: COUNT, MAX, MIN, AVG, SUM, DISTINCT. SQL COUNT (): This function returns the number of rows in the table that satisfies the condition specified in the WHERE condition.

Example :

Below The Related Topic Link:

Link (Character-Manipulative Functions) :

Link (Single Row Functions) :

Link (What is procedure and function in PL/SQL?) :

About the author


Leave a Comment