Q15
Which of the following is a SQL aggregate function?
A.
LEFT
B.
AVG
AnswerC.
JOIN
D.
LEN
Answer: Option B
Solution
Answer: Option B
Solution:
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