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!
Technical requirements ...
Get jOOQ Masterclass now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
