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

Aggregate window functions - SQL Tutorial

From the course: Advanced SQL – Window Functions

Start my 1-month free trial

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…

Contents