SELECT COUNT(MovieID) AS Expr1, MovieID
FROM online where logtime>'2008-10-1'
GROUP BY MovieID
ORDER BY COUNT(MovieID) DESC
转载于:https://www.cnblogs.com/smallmuda/archive/2008/10/07/1305273.html
转载于:https://www.cnblogs.com/smallmuda/archive/2008/10/07/1305273.html