Published 20 November 2017
Old-style TOP clause is used
It is recommended to use the new style TOP clause - TOP(n).
In order to limit the results of a query, you can specify the number you need by using the TOP clause. The TOP syntax is clearer with the parentheses, though they are syntactic sugar since only one parameter can be within parentheses.