Using ORDER BY in a View

Q. Why doesn’t SQL Server permit an ORDER BY clause in the definition of a view?

A. SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard.

Read More - Register for Free Membership