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.
V0159:
The specification states the following:
-
Subclause 7.13, "<query expression>": <fetch first clause> ::= FETCH { FIRST | NEXT } [ <fetch first quantity> ] { ROW | ROWS } { ONLY | WITH TIES } ... Conformance Rules: Without Feature F867, "FETCH FIRST clause: WITH TIES option", <fetch first clause> shall not contain WITH TIES.
Microsoft SQL Server 2008 R2varies as follows:
This feature is absent from the [ISO/IEC9075-2:2008] standard.
Microsoft SQL Server 2012 varies as follows:
Transact-SQL does not support this feature.