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.

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

What is an SQL Window Function? A window is a set of rows or observations in a table or result set. In a table, you may have more than one window depending on how you specify the query. A window ...