Menu

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

    Calculate averages with SQLite avg(), understand NULL values, empty groups, numeric conversion, and grouped averages with runnable examples.

  2. count

    Learn COUNT(*), COUNT(column), COUNT(DISTINCT), and FILTER in SQLite, including how NULL values and empty result sets affect counts.

  3. group_concat

    Learn to combine rows with SQLite group_concat(), choose a separator, control ordering, skip NULL values, and remove duplicates with runnable examples.

  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.