用mysql根据积分和时间计算排名

select id,integral,addtime from cos_member_vip order by integral desc,addtime asc

--如果需要生成以积分为最高优先，其次以时间为从高到低为条件生成个排名字段，可用

--ROW_NUMBER() OVER ()函数

select

*

from article as art

left join member as member

on art.mid = member.mid

order by art.ftime desc,member.score desc

limit 50

select min(user_integral) from (select top 600 user_integral from members order by user_integral desc)s

---