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

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

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com