我有一个视频播放表,我想对过去24小时内播放的视频进行排名,并将它们与24小时前的排名进行比较。因此,输出应该是VideoID、ID的当前排名和ID的前一天的排名PlayID (the specific id to the play table)VIDEOID (ID of the specific video, what needs to be ranked by most occurances)
playtime (linux
我正试图获得单一用户的排名位置。我已经有了获得全球排名的查询,但没有一个用户。BY `points` DESC) FROM `users`)) AS `rank` FROM `users` WHERE `user` = '1'SET @rank := 0; SELECT `user`, `points`, @rank := @rank + 1 AS `rank` FROM `users` ORDER BY`points` D