DuckDB has a min()
function just like most RDBMSs that returns the minimum value from a set of values. However, DuckDB’s implementation also allows us to return the bottom n
minimum values, which is not something we see in most other RDBMSs.
This article presents some examples of DuckDB’s implementation of the min()
function, so as to demonstrate its basic usage, as well as its bottom n
functionality.