mysql 按条件分组累计求和

select (select avg(sales) from 表名 b where (a.date-b.date) between 0 and 20) as [前20日平均销量],* from 表名 a

T是表，G是组，V是值：

分组、求和、求最大值：select G,MAX(SUM(V)) V1 from T group by G

求比值：

select T.G,SUM(T.V)/A.V1

from T,

(select G,MAX(SUM(V)) V1 from T group by G) A

where T.G=A.G

group by T.G

试试看，我没测试。

---