title: SQL query with limit
body: <p>I have this table in SQL Server:</p>
  
  <pre><code>ID   | videoid  | title
  =========================
  1    | id1      | title1
  2    | id2      | title2
  3    | id3      | title3
  </code></pre>
  
  <p>And I want to create select method that search in the title row with:</p>
  
  <pre><code>SELECT * FROM [movie].[dbo].[movies] 
  WHERE title like '%' + '%s' + '%'
  </code></pre>
  
  <p>And I'm looking for something like Limit in MySQL that from the <code>SELECT</code> results I will be able to get the <code>0-20,21-40,41-60</code> results.</p>
  
  <p>Any help with this query? </p>
  
  <p>I tried to use <code>LIMIT 0, 10</code> and I received this error:</p>
  
  <pre><code>Could not find stored procedure 'LIMIT'.
  </code></pre>