Order by error in creat view in sql server : **CREATE VIEW tblSanPham_VIEW 
AS 
SELECT TenSP, MaDanhMuc, Mamau
FROM tblSanPham 
ORDER BY MaSP DESC**

Msg 1033, Level 15, State 1, Procedure tblSanPham_VIEW, Line 6 [Batch Start Line 47]
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.