Chapter 13: Exploiting SQL Functions
From mathematical and statistical computations to string and date-time manipulations, respectively, to different types of aggregations, rankings, and groupings, SQL built-in functions are quite handy in many scenarios. There are different categories of functions depending on their goal and usage and, as you'll see, jOOQ has accorded major attention to their support. Based on these categories, our agenda for this chapter follows these points:
- Regular functions
- Aggregate functions
- Window functions
- Aggregates as window functions
- Aggregate functions and
ORDER BY - Ordered set aggregate functions (
WITHIN GROUP) - Grouping, filtering, distinctness, and functions
- Grouping sets
Let's get started!
