• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 46. Aggregates > Using Aggregate Functions

Using Aggregate Functions

The following five primary aggregate functions are supported by most major databases:

  • AVG calculates the average value of a numeric column.

  • COUNT obtains the number of rows that match a specific condition.

  • MAX obtains the greatest value in a numeric column.

  • MIN obtains the smallest value in a numeric column.

  • SUM obtains the total of all values in a numeric column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint