title: An SQL query with OFFSET/FETCH is returning unexpected results
body: <p>I have an SQL Server 2019 database table named <code>User</code> with 1,000 rows as follows:</p>
  <p><a href="https://i.stack.imgur.com/Dta7O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dta7O.png" alt="User Table" /></a></p>
  <p>I am having a hard time understanding how this <code>SELECT</code> query with <code>OFFSET</code>/<code>FETCH</code> is returning unexpected results:</p>
  <pre><code>SELECT * 
  FROM [User]
  WHERE (([NameGiven] LIKE '%1%') 
         OR ([NameFamily] LIKE '%2%'))
  ORDER BY [Id] ASC 
      OFFSET 200 ROWS FETCH NEXT 100 ROWS ONLY;
  </code></pre>
  <p>Query results:</p>
  <p><a href="https://i.stack.imgur.com/Zhd6D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Zhd6D.png" alt="Query Results" /></a></p>
  <p>The results range from 264 to 452 with a total of 100 rows. Why would the records 201, 211, etc. not show up? Am I wrong in my expectations or is there a mistake in the query criteria?</p>
  <p>If I remove the <code>OFFSET</code>/<code>FETCH</code> options from the <code>ORDER BY</code> clause, the results are as expected. That makes me think that the <code>WHERE</code> clause is not the problem.</p>
  <p>Any advice would be appreciated.</p>