title: How OrderBy happens in linq when all the records have the same value?
body: <p>When orderBy is happened on <code>datetime</code> with same value, I am getting different results in different hits from <code>linq</code> to <code>sql</code> . </p>
  
  <p>Let us  say some 15 records have the same datetime as one of their field
  and if pagination is there for those 15 records and per page limit is 10 in my case, say some 10 records came on 1st run for page 1. Then for page 2 I am not getting the remaining 5 records, but some 5 records from the previous 10 records of page 1. </p>
  
  <p>Question:</p>
  
  <ol>
  <li><p>How this orderBy and skip and take functions are working and</p></li>
  <li><p>Why this discrepancy in the result ?</p></li>
  </ol>