Most RDBMSs have a max() function and DuckDB is no exception. The max() function is a fundamental aggregate function in SQL that returns the maximum value from a set of values.
This article looks at how the max() function works in DuckDB, along with some simple examples to demonstrate.
array_agg() is an aggregate function in DuckDB that allows you to combine values from multiple rows into a list. This article explores how array_agg() works, along with some examples that demonstrate its usage.
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.
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 readingIn 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.
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.
The TAN() function in SQLite calculates the tangent of an angle provided in radians. The tangent is the ratio of sine to cosine (or the ratio of the opposite side to the adjacent side in a right triangle).
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.
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 readingIn 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.