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 →

DuckDB, an in-memory analytical SQL database management system, provides a good selection of functions for data manipulation and analysis. One of the these functions is list().

The list() function enables users to group multiple values into a single list, allowing for more advanced data aggregation and operations.

In this article, we’ll explore how the list() function works, along with some simple examples.

Continue reading →

DuckDB has a min_by() function that’s similar to the min() function, but with a twist. While the min() function simply returns the minimum value, the min_by() function finds the row with the minimum value in one column and returns the corresponding value from another column at that row.

Here are some examples that demonstrate how it works.

Continue reading →

In SQL databases, COUNT() is a commonly used aggregation function that returns the number of rows in a group. In this article, I run some examples of the COUNT() function in DuckDB. DuckDB is a high-performance analytical database system that’s designed to be fast, reliable, portable, and easy to use.

Continue reading →

DuckDB includes a reservoir_quantile() function that allows us to compute approximate quantiles efficiently. It provides the approximate quantile using reservoir sampling. This function can be handy when working with large datasets where exact quantile computation would be too slow or resource-intensive.

In this article, we will explore how the reservoir_quantile() function works, along with examples to demonstrate its usage.

Continue reading →

DuckDB is an in-process SQL OLAP database management system designed for analytical workloads. One of its handy features is the ability to compute approximate quantiles efficiently using the approx_quantile() function. This function is particularly useful when working with large datasets where exact quantile computation would be computationally expensive.

In this article, we will explore how the approx_quantile() function works, its syntax, and provide examples to demonstrate its usage.

Continue reading →