title: What is the T-SQL equivalent of MySQL syntax LIMIT x, y?
body: <blockquote>
  <p><strong>Possible Duplicate:</strong><br />
  <a href="https://stackoverflow.com/questions/10440057/how-to-write-a-mysql-limit-in-sql-server">How to write a (MySQL) “LIMIT” in SQL Server? </a></p>
  </blockquote>
  
  <p>How do I change my query with <code>LIMIT</code> for SQL-Server?</p>
  <pre><code>SELECT apretiz FROM tableApoint WHERE price = '$newprice' LIMIT 5;
  </code></pre>
  <p>How do I change <code>LIMIT 5,10</code>? Can I use <code>TOP</code> for it?</p>