ORDER BY clause in view in sql server

We cannot use ORDER BY clauses in view directly in sql server. For example:  

CREATE VIEW viewStudent

AS

SELECT * FROM Student ORDER BY 1

We will get error message like :

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

Solution: 

We must have to use either TOP or FOR XML. For example:

CREATE VIEW viewStudent

AS

SELECT TOP(5) * FROM Student ORDER BY 1


BETWEEN keyword in sql server
How to use variable in ORDER BY clause in sql server.
ORDER BY clause in common table expression in sql server.
ORDER BY clause in view in sql server.
OVER clause in aggregate function in sql server
Schema in sql server