title: Difference between Top and Limit Keyword in SQL
body: <p>A quick Question. Suppose I have the following two queries:</p>
  
  <pre><code>SELECT TOP 2 * FROM Persons;
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT * FROM Persons limit 2;
  </code></pre>
  
  <p>I want to know the difference between the execution of the above 2 queries?
  Basically, I want to know when should I use the <code>limit</code> keyword and when it is appropriate to use the <code>top</code> keyword. 
  Also, How does the database return results based on the above 2 queries.</p>