从一个月获得总数并限制结果MySQL

Question

I need to make a query that returns the top ten from a month. I hope this is possible directly through MySQL.

Basically I get some data every day (around 150 rows), with some information about different youtubers. Each row has an Identifier, a Date, the YouTuber, and the number of views the youtuber got that day. It looks like this:

ID|Date|Youtuber|Views
126|2013-01-28|example|482612

I need to sum all of the views and to a total, for a month. For example May, and then i need to get the results that has most views for that month.

How would I do that through mysql? Or would I need to use php as well? :)

Cheers

Answer 1

SELECT Youtuber, SUM(Views) as viewTotal FROM <TABLE> WHERE month(Date) = 5 GROUP BY Youtuber ORDER BY viewTotal LIMIT 0,10