获取重复次数最多的SQL

SELECT COUNT(MovieID) AS Expr1, MovieID
FROM online where logtime>'2008-10-1'
GROUP BY MovieID
ORDER BY COUNT(MovieID) DESC