O'Reilly logo
  • Dustin Waybright thinks this is interesting:

The thing with the ROW_NUMBER function—and window functions in general—is that they are only allowed in the SELECT and ORDER BY clauses of a query.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Thus the need for a derived table on which a filter predicate can be based.