Computer Science, asked by raj4088, 1 year ago

what is not built in aggregate function in SQL​

Answers

Answered by RITESHRAZZZZ
1

SQL does not include total as a built in aggregate function. The avg is used to find average, max is used to find the maximum and the count is used to count the number of values

HOPE THIS HELP U

PLZ MARK ME AS BRAINLIST

Answered by logaprabhasl
1

Answer:

Total is not built in aggregate function in SQL.

Explanation:

  • SQL is a domain specified language.
  • It is used in programming. 
  • It is designed for managing the data held in a relational database management system.
  • It is also for stream processing in a relational data stream management system.
  • Max refers to maximum in the SQL aggregate function.
  • MIN gives the minimum value of the set.
  • Total gives the value of total number of counts.
  • The avg is used to find the average in SQL aggregate function.
  • An aggregate function performs a function.
  • It performs calculation on a set of values and returns a single value.
  • Aggregate functions are often used to derive descriptive statistics.

#SPJ6

Similar questions