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