SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
SQL does indeed provide five built-in functions for aggregate operations:COUNT: Counts the number of rows or non-null values in a column.
SUM: Calculates the sum of numeric values in a column.
AVG: Computes the average of numeric values in a column.
MAX: Retrieves the maximum value from a column.
MIN: Retrieves the minimum value from a column.
These functions are fundamental for data analysis and reporting tasks within SQL queries.
Conclusion:
The statement "SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN" is Option A: True. Hence, the correct answer is True.
Join The Discussion