title: In SQL, how do you get the top N rows ordered by a certain column?
body: <p>I want to select the top N rows of a table, ranked by how high the number in one of their columns is.</p>
  
  <p>I already have:</p>
  
  <p><code>SELECT * FROM movie ORDER BY worldwide_gross DESC;</code></p>
  
  <p>How can I get the first twenty?</p>
  
  <p>If it makes any difference I'm using MySQL.</p>
  
  <p>Cheers!</p>