11.4.1 统计视频观看数 Top10

思路: 这个比较简单, 只需要按照views 全局排序, 然后取前 10 即可.

select 
    videoId, 
    uploader, 
    age, 
    category, 
    length, 
    views, 
    rate, 
    ratings, 
    comments 
from gulivideo_orc 
order by views desc
desc limit 10;
Copyright © 尚硅谷大数据 2019 all right reserved,powered by Gitbook
该文件最后修订时间: 2018-11-20 18:14:21

results matching ""

    No results matching ""