SQLite Aggregate Functions

SQLite aggregate functions are mainly used for data statistics, such as count, sum, average, etc. Aggregate functions combined with grouping operations allow you to count data in more dimensions.

  1. avg

    The SQLite avg() function calculates the average of all specified values ​​in a group and returns it.

  2. count

    The SQLite count() function counts all the specified values ​​in a group and returns it.

  3. group_concat

    The SQLite group_concat() function is an aggregate function that returns a string containing all specified values ​​in the group, separated by commas.

  4. max

    The SQLite max() function calculates the maximum value of all specified values ​​in a group and returns it.

  5. min

    The SQLite min() function computes the minimum value of all specified values ​​in a group and returns it.

  6. sum

    The SQLite sum() function computes the sum of all specified values ​​in a group and returns it.