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

Question

A. COUNT, SUM, AVG, MAX, MIN

B. SUM, AVG, MIN, MAX, MULT

C. SUM, AVG, MULT, DIV, MIN

D. SUM, AVG, MIN, MAX, NAME

Answer 1

The correct answer is option A (COUNT, SUM, AVG, MAX, MIN). All these are aggregate functions that are in-built functions provided by SQL. These five functions perform calculations on the result-set and return the single value.

• COUNT ­– count number of rows of a specified table
• SUM – returns the sum of result-set values
• AVG – returns the average value of the result-set values
• MAX – returns the maximum value of the result-set values
• MIN – returns the minimum value of the result-set values

You can check out this SQL Tutorial to learn all the in-built functions of SQL

To master SQL statements, queries and become proficient in SQL queries, enroll in our industry-recognized SQL course.