SQL: The ORDER BY clause is invalid in subqueries, unless TOP is also specified (Error 2148)

The SELECT - SQL Command cannot contain an SELECT - SQL Command - ORDER BY Clause in a Subquery unless a TOP expression is also included.