Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (153)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: aggregate functions

Understanding the BIT_XOR() Function in MySQL

Posted on May 15, 2023July 21, 2023 by Ian

In MySQL, the BIT_XOR() function returns the bitwise XOR of all bits in a given expression.

XOR is an exclusive OR, and so a XOR b is mathematically equal to (a AND (NOT b)) OR ((NOT a) and b).

Continue reading →
MySQL aggregate functions, aggregation, functions, what is, window functions

Understanding the BIT_OR() Function in MySQL

Posted on May 13, 2023July 21, 2023 by Ian

In MySQL, the BIT_OR() function returns the bitwise OR of all bits in a given expression.

Continue reading →
MySQL aggregate functions, aggregation, functions, what is, window functions

Understanding the BIT_AND() Function in MySQL

Posted on May 12, 2023July 21, 2023 by Ian

In MySQL, the BIT_AND() function returns the bitwise AND of all bits in a given expression.

Continue reading →
MySQL aggregate functions, aggregation, functions, what is, window functions

SQLite JSON_GROUP_OBJECT()

Posted on March 23, 2022April 2, 2022 by Ian

The SQLite json_group_object() function is an aggregate function that returns a JSON object comprised of all name/value pairs in the aggregation.

In other words, it constructs a JSON object from the values provided by its arguments.

Continue reading →
SQLite aggregate functions, aggregation, functions, json, what is

SQLite JSON_GROUP_ARRAY()

Posted on March 22, 2022April 28, 2024 by Ian

The SQLite json_group_array() function is an aggregate function that returns a JSON array comprised of all values in the aggregation.

In other words, it constructs an array from the values provided by its argument.

Continue reading →
SQLite aggregate functions, aggregation, arrays, functions, json, what is

SUM() Function in PostgreSQL

Posted on December 29, 2021 by Ian

In PostgreSQL, the SUM() function computes the sum of the non-null input values and returns the result.

In other words, it adds numbers and returns the result.

Continue reading →
PostgreSQL aggregate functions, aggregation, functions, what is

AVG() Function in PostgreSQL

Posted on December 26, 2021 by Ian

In PostgreSQL, the AVG() function computes the average (arithmetic mean) of all the non-null input values, and returns the result.

Continue reading →
PostgreSQL aggregate functions, aggregation, functions, what is

MAX() Function in PostgreSQL

Posted on December 14, 2021 by Ian

In PostgreSQL, the MAX() function computes the maximum of the non-null input values and returns the result.

This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.

Continue reading →
PostgreSQL aggregate functions, aggregation, functions, what is

MIN() Function in PostgreSQL

Posted on December 14, 2021 by Ian

In PostgreSQL, the MIN() function computes the minimum of the non-null input values and returns the result.

This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.

Continue reading →
PostgreSQL aggregate functions, aggregation, functions, what is

SUM() Function in MySQL

Posted on December 10, 2021July 21, 2023 by Ian

In MySQL, 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 reading →
MySQL aggregate functions, aggregation, functions, what is, window functions
  • «
  • 1
  • …
  • 5
  • 6
  • 7
  • 8
  • 9
  • …
  • 11
  • »

About Database.Guide | Privacy Policy