Answers

Question and Answer:

  Home  Database Developer

⟩ Tell me what are aggregate functions in SQL?

SQL aggregate functions return a single value, calculated from values in a column. Some of the aggregate functions in SQL are as follows

☛ AVG() – This function returns the average value

☛ COUNT() – This function returns the number of rows

☛ MAX() – This function returns the largest value

☛ MIN() – This function returns the smallest value

☛ ROUND() – This function rounds a numeric field to the number of decimals specified

☛ SUM() – This function returns the sum

 179 views

More Questions for you: