title: SQL Query to select bottom 2 from each category
body: <p>In Mysql, I want to select the bottom 2 items from each category</p>
  
  <pre><code>Category Value
  1        1.3
  1        4.8
  1        3.7
  1        1.6
  2        9.5
  2        9.9
  2        9.2
  2        10.3
  3        4
  3        8
  3        16
  </code></pre>
  
  <p>Giving me:</p>
  
  <pre><code>Category Value
  1        1.3
  1        1.6
  2        9.5
  2        9.2
  3        4
  3        8
  </code></pre>
  
  <p>Before I migrated from sqlite3 I had to first select a lowest from each category, then excluding anything that joined to that, I had to again select the lowest from each category.  Then anything equal to that new lowest or less in a category won.  This would also pick more than 2 in case of a tie, which was annoying... It also had a really long runtime.</p>
  
  <p>My ultimate goal is to count the number of times an individual is in one of the lowest 2 of a category (there is also a name field) and this is the one part I don't know how to do.
  Thanks</p>