mysql实现某个时间数据段统计排名 MySQL select *,(@rowNo:=@rowNo+1) as pmfrom(select id,sum(value) as sumValuefrom youTable as pwhere p.date BETWEEN DATE_FORMAT('2014-06-01','%Y-%m-%d 00:00:00') AND DATE_FORMAT('2014-07-04','%Y-%m-%d 23:59:59
mysql实现某个时间数据段统计排名 MySQLselect *,(@rowNo:=@rowNo+1) as pm from( select id,sum(value) as sumValue from youTable as p where p.date BETWEEN DATE_FORMAT('2014-06-01','%Y-%m-%d 00:00:00') AND DATE_FORMAT('2014-07-04','%Y-%m-%d 23:59:59') group by id order by sumValue desc )as rs ,(select @rowNo:=0) pm
已抢65049个
抢已抢28178个
抢已抢15193个
抢已抢7622个
抢已抢9514个
抢已抢19295个
抢