How to use ORDER BY in a view

You can’t use ORDER BY in view, if you try to include ORDER BY in View, it will throw the following error. This is a limitations of the view in SQL SERVER. However you can use ORDER BY with TOP 100 PERCENT, don’t think too much that’s how it works :)

Cheers! Uma