The AVG function returns an average of all rows from a select column including any NULL values.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- A table has the following data: [[5, Null, 10]].What will the average function return ?
- A table has the following data : [[5, Null, 10]].What will the average function return ?
- How can we calculate average of a column?
- NULL values are ingnored for all SQL: 2008 aggregate functions.
- select avg(dummy) from dual; o/p:
- You can use Avg or Sum group functions for any numeric data
- You can use Avg or Sum group functions for any numeric data
- You can use Avg or Sum group functions for any numeric data