Re: Challenge while using row_number()

[Mikael Eriksson]

I don't think this question was overly complicated, unless one wants to complicate it. At another forum my question was understood fully as such, and the following solution (which works nicely) was provided.

WITH cte AS ( SELECT f6... )
SELECT ROW_NUMBER()
OVER (ORDER BY cp DESC, f1 DESC, f2 DESC
, f3 DESC, f4 DESC, f5 DESC) AS pos
, cte.*
FROM cte

But I'm still wondering why order by-part doesn't see my renamed column name.

--m