title: How do I write LINQ's .Skip(1000).Take(100) in pure SQL?
body: <p>What is the SQL equivalent of the <code>.Skip()</code> method in LINQ?</p>
  
  <p>For example: I would like to select rows 1000-1100 from a specific database table.</p>
  
  <p>Is this possible with just SQL? Or do I need to select the entire table, then find the rows in memory? I'd ideally like to avoid this, if possible, since the table can be quite large.</p>