Share via


2.1.2.123 F867, FETCH FIRST clause: WITH TIES option

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.