首页 > 数据库技术 > 详细

mysql排序row_number

时间:2018-02-23 20:20:45      阅读:232      评论:0      收藏:0      [点我收藏+]

select ‘top3‘ as top,news_id,count(1) as counts from (
SELECT
news_id,
pv,
row_number () over (
PARTITION BY statis_date
ORDER BY
pv DESC
) row_num
FROM
author_pv
WHERE
statis_date = ‘${yesterday}‘ and settle_type=2)t1 where t1.row_num between 41 and 60 group by news_id

mysql排序row_number

原文:https://www.cnblogs.com/tqliu/p/8463011.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!