获取重复次数最多的SQL SELECT COUNT(MovieID) AS Expr1, MovieID FROM online where logtime>'2008-10-1' GROUP BY MovieID ORDER BY COUNT(MovieID) DESC