Share via


2.1.2.120 F858, <fetch first clause> in subqueries

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.