Limit number of occurrences of Group By

By default MySQL does not do this, but we can improvise.

Assuming your original query is

SELECT id, data, SUM(visualizacoes)
FROM tabela
GROUP BY id, data 
ORDER BY id, data DESC;

Place your query in a subquery, an extra column will be added which will count the redo of certain id :

SELECT id, data, totalVisualizacoes,
@currcount := IF(@currvalue = id, @currcount + 1, 1) AS rank,
@currvalue := id FROM (
    SELECT id, data, SUM(visualizacoes) AS totalVisualizacoes
    FROM tabela
    GROUP BY id, data 
    ORDER BY id, data DESC;
) AS totais;

Finally, make the final query that will filter the number of occurrences:

SELECT id, data, totalVisualizacoes FROM (
    SELECT id, data, totalVisualizacoes,
    @currcount := IF(@currvalue = id, @currcount + 1, 1) AS rank,
    @currvalue := id FROM (
        SELECT id, data, SUM(visualizacoes) AS totalVisualizacoes
        FROM tabela
        GROUP BY id, data
        ORDER BY id, data DESC
    ) AS totaisPorData
) AS totalLimitado
WHERE rank <= 3;

Example on slqfiddle .

Reference

I was having a very similar problem and I could not resolve it using the gmsantos answer , however I found another answer very similar by the user Salman A (link to the answer) , that's when I was able to understand how the count of occurrences of a value in a specific field, it worked 100% for me!
Pay attention to the first line where you have:

SET @currcount = NULL, @currvalue = NULL;

This line must always be present for the occurrence count to work. (If you are editing the sql in phpmyadmin this line will disappear if you execute the query and click edit again)

Note: My problem was to select the last 20 offers of each company in the bank