15
Which of the following is a SQL aggregate function?
- ALEFT
- BAVG
- CJOIN
- DLEN
Correct answer: B
Discussion 1
Log in or create a free account to reply and vote.
0
CCommunity
AVG
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
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