title: "paging" SELECT SQL server
body: <p>I have a table with 100 rows, and want to SELECT just a part of them(for example from row 20 to 30), like "paging" the SELECT. </p>
  
  <p>which is an efficient way to do that in SQL Server 2008 R2?</p>