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:00:00') AND DATE_FORMAT('2014-07-04','%Y-%m-%d 23:59:59

mysql实现某个时间数据段统计排名 MySQL

select *,(@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