using order by clause when defining a query

[jmodic]

You can use ORDER BY in a view from 8.1.* onwards. In 8.0.* and before it was not allowed.