Home >> Oracle >> AVG() aggregate function in Oracle

AVG() aggregate function in Oracle

Return average value of epression & ignoring NULL values in a column.

Syntax
AVG(expression)

Example
SELECT AVG(price) FROM products

Post Your Comment

Next Questions
COLLECT() Aggregate Function
CORR() Aggregate Function
CORR_*
COUNT() aggregate function
COVAR_POP Aggregate Function
COVAR_SAMP() Aggregate Function
CUME_DIST() Aggregate Function
DENSE_RANK() Aggregate Function
FIRST() aggregate function
GROUP_ID() Aggregate Function
GROUPING() Aggregate Function
GROUPING_ID() Aggregate Function
LAST() aggregate function
LISTAGG() Aggregate Function
MAX() aggregate function
MEDIAN() Aggregate Function
MIN() Aggregate Function
PERCENT_RANK() Aggregate Function
PERCENTILE_CONT() Aggregate Function
PERCENTILE_DISC() Aggregate Function
RANK() Aggregate Function
REGR_() Aggregate Function
STATS_BINOMIAL_TEST() Aggregate Function
STATS_CROSSTAB() Aggregate Function
STATS_F_TEST() Aggregate Function

Copyright ©2022 coderraj.com. All Rights Reserved.