Order By in View

Question

In case of view Order By is supported or not ?

Arjun Panwar · Answer

Thanks Mr.Narayan

Vulpes · Answer

I don't know about other databases but in SQL Server you can't use ORDER BY on a VIEW unless you also use TOP or FOR XML in the same query.

Satyapriya Nayak · Answer

Hi Arjun ORDER BY clause is not supported in views . Please refer the below link http://blog.sqlauthority.com/2007/08/12/sql-server-fix-error-msg-1033-level-15-state-1-the-order-by-clause-is-invalid-in-views-inline-functions-derived-tables-subqueries-and-common-table-expressions-unless-top-or-for-xml-is-als/ http://stackoverflow.com/questions/1306359/order-by-in-a-sql-server-2008-view Thanks

Narayan · Answer

Yes it is supported but you have to write top something like this CREATE VIEW [dbo].[View_1] AS SELECT TOP (100) PERCENT ID Name FROM dbo.Country ORDER BY Name