:::: MENU ::::

The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

  • May 07 / 2009
  • 0
dbDigger, T-SQL Interview Questions

The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

The 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.
is a run time error message of severity level 15. This error message appears when you try to call any view, function, derived table or subquery without also specifying TOP or FOR XML. To resolve the error message add the TOP or FOR XML clause to the statement

Consult us to explore the Databases. Contact us