Which of the following is a SQL aggregate function?
A. LEFT
B. AVG
C. JOIN
D. LEN
Answer: Option B
Solution (By Examveda Team)
SQL has several arithmetic functions to do math on the numbers, such as summing up, taking average, retrieved from the column. They are:
AVG():- Average of the column
COUNT():- Number of records
MAX():- maximum of the column
MIN():- minimum of the column
SUM():- Sum of the column
This Question Belongs to SQL >> Sql Miscellaneous
Join The Discussion