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.

Sorry if the subject was fuzzy..As a trivial test case I'm logging CPU utilization to SQL server with a sample rate of 1 second.Now, lets say I log this for 10 minutes. I wanna return the average ...