title: Where clause with fetch next row
body: <p>How to user where clause with fetch next in sql query. My query ends like:</p>
  
  <pre><code> 10 ROWS FETCH NEXT 5 ROWS ONLY WHERE table.FullName LIKE '%name%' 
  </code></pre>
  
  <p>Am getting error in where clause.</p>
  
  <p><a href="http://i.stack.imgur.com/CZ4rC.png" rel="nofollow">error message</a></p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'WHERE'</p>
  </blockquote>
  
  <p><strong>EDIT:</strong></p>
  
  <pre><code>select * 
  from table name  
  WHERE FullName LIKE '%name%' 
  ORDER BY FullName 
  OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY
  </code></pre>
  
  <p>The query will work when i remove the statement <code>'OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY'</code></p>