title: Is there a way to get 2 rows from each group of rows?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2886064/how-do-i-select-a-fixed-number-of-rows-for-each-group">How do I select a fixed number of rows for each group?</a>  </p>
  </blockquote>
  
  
  
  <p>For example... if I have this table (sorted by color):</p>
  
  <pre><code>--------------
  | id | color |
  --------------
  | 95 | red   |
  | 7  | red   |
  | 44 | red   |
  | 46 | red   |
  | 49 | red   |
  | 24 | green |
  | 37 | green |
  | 91 | green |
  | 88 | green |
  | 44 | blue  |
  | 10 | blue  |
  | 11 | blue  |
  --------------
  </code></pre>
  
  <p>Is there a way for me to get the 2 rows from each color? Example:</p>
  
  <pre><code>--------------
  | id | color |
  --------------
  | 7  | red   |
  | 44 | red   |
  | 24 | green |
  | 37 | green |
  | 10 | blue  |
  | 11 | blue  |
  --------------
  </code></pre>