aggregate functions – Page 10

MariaDB GROUP_CONCAT()

November 6, 2021November 6, 2021 by Ian

MariaDB has a GROUP_CONCAT() function that enables us to return columns from a query as a delimited list.

STRING_AGG() Function in PostgreSQL

November 6, 2021 by Ian

In PostgreSQL, we can use the STRING_AGG() function to return columns from a query as a delimited list.

SQL UNION Clause for Beginners

October 22, 2023December 8, 2020 by Ian

In SQL, the UNION clause concatenates the results of two queries into a single result set.

You can use the UNION clause with or without the ALL argument:

UNION ALL – Includes duplicates.
UNION – Excludes duplicates.

Some RDBMSs also accept UNION DISTINCT, which is the equivalent to UNION. That is, it excludes duplicates.

Below are some basic examples to demonstrate how it works.

SQL AVG() for Beginners

July 23, 2023December 8, 2020 by Ian

In SQL, the AVG() function is an aggregate function that returns the average of all values in a given expression.

It can also be used to return the average of all distinct (unique) values in an expression.

The expression must be numeric (it cannot be character string, bit string, or datetime).

Below are some basic examples to demonstrate how it works.

SQL SUM() for Beginners

July 23, 2023December 8, 2020 by Ian

In SQL, the SUM() function is an aggregate function that returns the sum of all values in a given expression.

It can also be used to return the sum of all distinct (unique) values in an expression.

The expression must be numeric (it cannot be character string, bit string, or datetime).

Below are some basic examples to demonstrate how it works.

SQL MAX() for Beginners

July 23, 2023December 7, 2020 by Ian

In SQL, the MAX() function is an aggregate function that returns the maximum value in a given expression.

Below are some basic examples to demonstrate how it works.

SQL MIN() for Beginners

July 23, 2023December 7, 2020 by Ian

In SQL, the MIN() function is an aggregate function that returns the minimum value in a given expression.

Below are some basic examples to demonstrate how it works.

SQL COUNT() for Beginners

July 23, 2023December 7, 2020 by Ian

In SQL, the COUNT() function is an aggregate function that returns the number of items found in a group.

You can use COUNT() in multiple parts of a query. For example, you can use it in the SELECT list, or the HAVING clause when filtering groups.

SQLite Aggregate Functions

May 28, 2020May 28, 2020 by Ian

This page contains a list of aggregate functions that are available in SQLite by default.

How Group_Concat() Works in SQLite

November 7, 2021May 21, 2020 by Ian

SQLite has a group_concat() function that allows you to concatenate multiple results returned for a column into one.

This is sometimes referred to as “string aggregation”.

For example, when querying a database, instead of having each column’s value output in a new row, you can use group_concat() to have them output as a comma separated list.