mysql实现ROW_NUMBER()sql排名: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:0