[SQL Server] the order by clause is invalid in expressions such as views, derived tables, and subqueries.

By default, if you try to use order by in subqueries, functions, and views,

Create ViewDBO. vsortedordersAsSelectOrderid, customeridFromDBO. OrdersOrder ByOrderidgo

 

The following error may occur:

Message 1033, Level 15, status 1, 4th rowsUnless Top Or For XML,Otherwise,Order By The clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions.

 
The reason is that the SELECT statement for a table does not actually return a table but a cursor. 
 

  what if necessary? The answer is to work with top 100 percent. 
     code highlighting produced by actipro codehighlighter (freeware) 
 http://www.CodeHighlighter.com/
 -->  select top (  100  ) percent orderid, customerid 
 from DBO. orders 
 order by orderid, customerid DESC