In DuckDB, the bit_xor() function returns the bitwise XOR of all bits in a given expression.
Here are some basic examples that demonstrate how the bit_xor() function works in DuckDB.
Tag: aggregate functions
BOOL_OR() Examples in DuckDB
In DuckDB, the bool_or() aggregate function returns true if any input value is true, otherwise it returns false.
Here are some basic examples that demonstrate how it works.
Continue readingA Quick Look at DuckDB’s BIT_OR() Function
In DuckDB, the bit_or() function returns the bitwise OR of all bits in a given expression.
Let’s see how the bit_or() function works in DuckDB with some basic examples.
Exploring the BIT_AND() Function in DuckDB
In DuckDB, the bit_and() function returns the bitwise AND of all bits in a given expression.
Let’s take a quick look at the bit_and() function, along with some simple examples.
Using DuckDB’s FAVG() Function for More Accurate Floating Point Averages
The favg() function in DuckDB calculates averages using a floating point summation method known as Kahan summation (or compensated summation). This method helps reduce the accumulation of rounding errors that can occur when many floating point numbers are involved when using the regular avg() function.
A Quick Look at the AVG() Function in DuckDB
In DuckDB, avg() is an aggregate function that returns the average of all non-NULL values in its argument (usually a column).
In this article we’ll take a quick look at this function, along with some basic examples.
Continue readingAn Overview of ARG_MIN() in DuckDB
In DuckDB, arg_min() is an aggregate function that finds the row with the minimum value in one column and returns the corresponding value from another column at that row. Rows where either of the first two expressions is NULL are ignored.
In this article we explore DuckDB’s arg_min() function with some simple examples.
Exploring the ARG_MAX() Function in DuckDB
In DuckDB, arg_max() is an aggregate function that finds the row with the maximum value in one column and returns the corresponding value from another column at that row. Rows where either of the first two arguments is NULL are ignored.
Let’s take a look at the arg_max() with some straightforward examples.
Exploring the ANY_VALUE() Function in DuckDB
DuckDB is a fast and reliable analytical database that offers a bunch of aggregate functions. One such function is ANY_VALUE().
In this post, we’ll explore the ANY_VALUE() function, along with examples to demonstrate its usage.
A Quick Overview of ARRAY_AGG() in PostgreSQL
PostgreSQL has an aggregate function called array_agg() that allows us to generate an array from the result set of a query.
The function accepts an argument which is used to generate the array. This argument is typically the column that we want to use in order to populate the array.
Continue reading