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 provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.