Oracle, SQL Server, Postgres, DB2 - the list goes on.<BR><BR>The reality is you have to restructure your query. A CTE isn't necessary, but will likely make the query more readable.

SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like “group by,” have access to individual rows and can even add some of ...

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 ...