title: Is there a way to LIMIT results per group of result rows in MySQL?
body: <p>I have the following query:</p>
  
  <pre><code>SELECT title, karma, DATE(date_uploaded) as d
  FROM image
  ORDER BY d DESC, karma DESC
  </code></pre>
  
  <p>This will give me a list of image records, first sorted by newest day, and then by most karma.</p>
  
  <p>There is just one thing missing: I want to only get the x images with the highest karma per day. So for example, per day I only want the 10 most karma images. I could of course run multiple queries, one per day, and then combine the results.</p>
  
  <p>I was wondering if there is a smarter way that still performs well. I guess what I am looking for is a way to use LIMIT x,y per group of results?</p>