What are Group Functions in Oracle?

What are Group Functions in Oracle?

- COUNT():
This function returns the number of rows in the group. A column name or ‘*’ may be passed as a parameter.

- MIN(column_name):
This function returns the minimum value of the expression evaluated on each row of the group.

- MAX(column_name):
It returns the maximum value of the expression evaluated on each row of the group.

- AVG(column_name):
It returns the average value of the expression evaluated on each row of the group.
WHERE clause vs HAVING clause
WHERE clause vs HAVING clause - HAVING clause is used with group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns...
Function VS Procedure
Function VS Procedure - A FUNCTION always returns a value using the return statement while a PROCEDURE may return one or more values through parameters or may not return at all...
Oracle numeric functions
Oracle numeric functions - NVL, ABS,CEIL,FLOOR, MOD, SQRT, EXP,LN AND LOG, ROUND AND TRUNC, AVG, COUNT, MAX, MIN AND SUM...
Post your comment

Related Content

Follow us

▲