WITH common_table_expression (Transact-SQL) ... Transact-SQL 語法慣例 ... 只有在SELECT 陳述式中,且只在指定了ORDER BY 子句時,才能指定TOP...WITH ...
msdn.microsoft.com