title: Return all rows with the "MAX" value in SQL?
body: <p>I have the following table:</p>
  
  <p>Table: Scores
  What I have:</p>
  
  <pre>
  +----+-------+
  | Id | value |
  +----+-------+
  |  1 |   300 |
  |  2 |   300 |
  |  3 |   300 |
  |  4 |   100 |
  |  5 |   200 |
  +----+-------+
  </pre>
  
  <p>What I need:</p>
  
  <pre>
  +----+-------+
  | Id | value |
  +----+-------+
  |  1 |   300 |
  |  2 |   300 |
  |  3 |   300 |
  --------------
  </pre>
  
  <p>How would I grab "all" the top scores id 1, 2, 3 in SQL.  I started off using MAX (in mysql) but that only returns one row.  </p>