Vidyalelo
SQL · Q15

SQL

Programming · SQL · question 15

Q15

Which of the following is a SQL aggregate function?

A.
LEFT
B.
AVG
Answer
C.
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