Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0156:
The specification states the following:
-
Subclause 7.13, "<query expression>": <query expression> ::= [ <with clause> ] <query expression body> [ <order by clause> ] [ <fetch first clause> ] ... <fetch first clause> ::= FETCH FIRST [ <unsigned integer> ] { ROW | ROWS } ONLY ... Conformance Rules Without Feature F858, "<fetch first clause> in subqueries", in conforming SQL language, a <query expression> contained in another <query expression> shall not immediately contain a <fetch first clause>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.