Error Message:
Msg 1033, Level 15, State 1, Line 5
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
Severity level:
15.
Description:
This error message appears, when you try to call one of the above mentioned constructs without specifying also TOP or FOR XML.
Consequences:
The SQL statement cannot be parsed and further execution is stopped.
Resolution:
Error of the Severity Level 15 are generated by the user and can be fixed by the SQL Server user. You must add the TOP or FOR XML clause to the statement.
Versions:
All versions of SQL Server.
Example(s):
SELECT *
FROM
(SELECT *
FROM Northwind.dbo.Orders
ORDER BY OrderID)
Remarks:
In the above example the derived table is queried without the use of TOP or FOR XML. This raises the error.