ExamVeda
Login
Home
This question belongs to Database Introduction To SQL
Introduction to SQL
?

Which of the following are the five built-in functions provided by SQL?

Answer & Solution
Correct Answer: Option A
Option A: COUNT, SUM, AVG, MAX, MIN - These are the five built-in aggregate functions provided by SQL:
COUNT: Returns the number of rows that match a specified criterion.
SUM: Returns the sum of values in a numeric column.
AVG: Returns the average of values in a numeric column.
MAX: Returns the maximum value in a column.
MIN: Returns the minimum value in a column.
Option B: SUM, AVG, MIN, MAX, MULT - "MULT" is not a standard SQL function. This option is incorrect. Option C: SUM, AVG, MULT, DIV, MIN - "MULT" and "DIV" are not standard SQL functions. This option is incorrect. Option D: SUM, AVG, MIN, MAX, NAME - "NAME" is not a standard SQL function. This option is incorrect. Conclusion:
The five built-in functions provided by SQL for performing aggregate calculations on data are Option A: COUNT, SUM, AVG, MAX, MIN.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Peter Mademla
Peter Mademla 5 years ago
What are those terms refers?