COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average function
|
|
|
AVG() function
|
|
|
Average ____ Value function
|
|
|
None of these
|
Detailed explanation-1: -The AVG function returns the average (arithmetic mean) of the input expression values. The AVG function works with numeric values and ignores NULL values.
Detailed explanation-2: -The AVG() function returns the average value of an expression.
Detailed explanation-3: -The AVG() function returns the average value of a numeric column.
Detailed explanation-4: -SQL AVG function is used to find out the average of a field in various records. You can take average of various records set using GROUP BY clause. Following example will take average all the records related to a single person and you will have average typed pages by every person.
Detailed explanation-5: -In SQL, SUM() and AVG() functions are used to calculate total and average values in numeric columns.