In MariaDB, the SUM() aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in an expression.
Continue readingTag: window functions
MIN() Function in MariaDB
In MariaDB, MIN() is an aggregate function that returns the minimum value in a given expression.
MAX() Function in MariaDB
In MariaDB, MAX() is an aggregate function that returns the maximum value in a given expression.
SQL AVG() for Beginners
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.
Continue readingSQL SUM() for Beginners
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.
Continue readingSQL MAX() for Beginners
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.
Continue readingSQL MIN() for Beginners
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.
Continue readingSQL COUNT() for Beginners
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.
MIN() – Find the Minimum Value in a Column in MySQL
The MySQL MIN() function is an aggregate function that returns the minimum value from an expression.
Typically, the expression would be a range of values returned as separate rows in a column, and you can use this function to find the minimum value from the returned rows. If there are no matching rows, MIN() returns NULL.
For example, you can use this function to find out which city has the smallest population out of a list of cities.
MAX() – Find the Maximum Value in a Column in MySQL
The MySQL MAX() function is an aggregate function that returns the maximum value from an expression.
Typically, the expression would be a range of values returned as separate rows in a column, and you can use this function to find the maximum value from the returned rows. If there are no matching rows, MAX() returns NULL.
For example, you can use this function to find out which city has the largest population out of a list of cities.