Hi!I often run queries on my company’s Data Warehouse, which runs DB2. Due to the nature of my permissions, I cannot create Views or new Tables – thus, everything generally has to be done in a ...

The AGGREGATE Syntax Before we look at some examples of the AGGREGATE function in use, let's see how it works.

In addition to using subselects to examine data in related tables, it’s also possible to use an aggregate function in a WHERE clause subselect to make a determination about the primary result set.

I'm trying to come up with a query format that will allow me to return multiple rows of aggregate data grouped by DATE, but the date values would be BETWEEN certain intervals.As in, the data would ...