In DuckDB, the arg_max_null() function works in a similar way to the arg_max() function, in that it finds the row with the maximum value in one column and returns the corresponding value from another column at that row.

But where it differs from arg_max() is in the way it deals with NULL values. Also, arg_max_null() only accepts two arguments, whereas arg_max() accepts an optional third argument. Additionally, there aren’t any aliases for arg_max_null() at the time of writing (arg_max() has a couple of aliases).

In this article we’ll look at how arg_max_null() works, and we’ll compare it with arg_max() to see how each function handles NULL values.

Continue reading →

DuckDB is an in-process SQL OLAP database management system designed for analytical workloads. Among its many functions is one called last(). This function returns the last value in a column.

Let’s take a look at the last() function in DuckDB.

Continue reading →

DuckDB has a max_by() function that finds the row with the maximum value in one column and returns the corresponding value from another column at that row.

Below are some examples that demonstrate how it works.

Continue reading →

One of the aggregate functions available in DuckDB is the FIRST() function, which returns the first value from each group in a query.

Let’s take a look at some examples of using the FIRST() function in DuckDB

Continue reading →

One of the more commonly used aggregate functions in SQL databases is the sum() function, which provides an easy way to calculate the total sum of a numeric column. DuckDB is no exception.

In this article, we’ll explore how the sum() function works in DuckDB, along with some straightforward examples to demonstrate.

Continue reading →