SELECT * FROM 
   (SELECT TOP 10 * FROM FooTable ORDER BY X DESC) as myAlias 
ORDER BY X ASC 

即，您的子查询可能需要别名，但除此之外，它应该可以工作。