title: top 10 by category mysql
body: <p>I have a table where I have to get top 10 in each category based on the amount spent by a person in that category. My sample data is </p>
  
  <pre><code>person category amount
  roger  perfume   20
  jim    perfume   50
  joe    tv        5
  jim    tv        25
  kathy  car       40
  alicia perfume   100
  </code></pre>
  
  <p>I gotta get this in one query. I know limit does not work on <strong>amount</strong> like <strong>limit amount 10</strong>. Please help</p>