title: SQL Server 'FETCH FIRST 1 ROWS ONLY' Invalid usage
body: <p>I am trying to convert a Db2 query to SQL Server, I came across a construct I am not familiar with: FETCH  FIRST 1 ROWS ONLY.</p>
  
  <p>This is the query working on db2:</p>
  
  <pre><code>select * from products.series where state = 'xxx' order by id 
  FETCH FIRST 1 ROWS ONLY
  </code></pre>
  
  <p>and the error I am getting on SQL Server:</p>
  
  <pre><code>Invalid usage of the option FIRST in the FETCH statement.
  </code></pre>
  
  <p>I have tried replacing FIRST with NEXT which seems to be admitted in SQL Server, but with no success.</p>
  
  <p>I am using SQL Sever 2014</p>