T-SQL provides TOP, which can be used alone (and is nondeterministic) or with ORDER BY (deterministic if the order by list is a key) as an extention to standard SQL. Unfortunately, this causes a lot of confusion. People (and some tools) put TOP 100 PERCENT .. ORDER BY in views, and more importantly, people use TOP without ORDER BY and expect things they don't get. There are further confusions when TOP is used in a UNION query. Since only one ORDER BY clause is allowed. TOP .. ORDER BY is not available, or it is only with some messy subqueries or WITH clauses.
Finally, an ORDER BY clause is ambiguous. If there is no matching TOP clause, it orders the results presented to the client. If there is a TOP clause, the results are not guaranteed to be presented on order, which is difficult to explain.