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
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....