Examveda
Examveda

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

Join The Discussion

Related Questions on Sql Miscellaneous