欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

mysql实现ROW_NUMBER() sql 排名

程序员文章站 2024-01-01 18:29:28
...

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

上一篇:

下一篇: