From the course: Advanced SQL – Window Functions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Aggregate window functions - SQL Tutorial
From the course: Advanced SQL – Window Functions
Aggregate window functions
- [Narrator] These are the common categories for aggregate functions. Most databases support most aggregate group functions as aggregate window functions too. You've probably used a few of these before, most likely, the arithmetic ones. Trivia fact, the word arithmetic comes from number art. Arithmos is number and tic is art. The NC SQL standard defines Boolean aggregate functions called every, any and some. Array aggregations are often extended to support JSON and XML formats. Statistical aggregates are plentiful and we're going to see a few later. And some databases add their own proprietary functions such as, Bitwise aggregations and Approximate functions that can offer better performance when accuracy is not critical. I can probably author a whole course just on aggregations. Now that I say it out loud, it actually sounds like a decent idea. Let me know in the Q and A section if you would like to see a course…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.