Aggregate functions summarize sets of rows; single-row functions transform values for each row independently. This chapter covers numeric functions and ways to handle missing values. Function names and NULL behavior can vary by database, so dialect-specific cases are labeled.
Single-Row Functions
Transform values without collapsing rows