title: MySql: Set limit for duplicate column
body: <p>OK I have a column on my table called style_number. There can be duplicates of style_number. I want to select everything, but only up to 3 for each style number.</p>
  
  <p>So for example if there are 4 rows that have a style_number = "style 7" only 3 of those 4 would be selected (doesn't matter which 3, any 3).</p>
  
  <p>Does this make sense?</p>
  
  <p>How can I do that?</p>
  
  <p>Thanks!!</p>
  
  <p>Note: I am using 4.1.22</p>
  
  <p>EDIT:
  To clear some confusion. I need all the other columns as well, and I need more than just "style 7" or I could easily limit to 3. but for example if this where my table:</p>
  
  <p>style_number | price | stone_count</p>
  
  <pre><code>"style 7" | 300 | 2
  "style 7" | 400 | 3
  "style 7" | 500 | 4
  "style 7" | 600 | 5
  "style 8" | 200| 1
  "style 8" | 300 | 2
  </code></pre>
  
  <p>I would get this as a result:</p>
  
  <pre><code>"style 7" | 300 | 2
  "style 7" | 400 | 3
  "style 7" | 500 | 4
  "style 8" | 200| 1
  "style 8" | 300 | 2
  </code></pre>
  
  <p>Does that make better sense?</p>