title: In SQL, how to select the top 2 rows for each group
body: <p>I have a table as following:</p>
  
  <pre><code>NAME    SCORE
  -----------------
  willy       1
  willy       2
  willy       3
  zoe         4
  zoe         5
  zoe         6
  </code></pre>
  
  <p>Here's the <a href="http://www.sqlfiddle.com/#!2/ee665/1" rel="noreferrer">sample</a></p>
  
  <p>The aggregation function for <code>group by</code> only allow me to get the highest score for each <code>name</code>.
  I would like to make a query to get the highest 2 score for each <code>name</code>, how should I do?</p>
  
  <p>My expected output is </p>
  
  <pre><code>NAME    SCORE
  -----------------
  willy       2
  willy       3
  zoe         5
  zoe         6
  </code></pre>