求mysql一周内时间总和的sql语句

一周内总和表达不太清楚···你是先看到这一周内的所有信息···还是想对某一个字段进行一周内的求和？select * from 表 where 时间字段 between adddate(curdate(),-6) and adddate(curdate(),1)如果是对某各字段求和就是select sum(字段) from 表 where 时间字段 between adddate(curdate(),-6) and adddate(curdate(),1)

select book_subtime,sum(book_count) book_count

from n_column as n1, n_column_count as n2 where n1.column_xiaoshuo_state=1 and n1.column_id = n2.column_id

group by book_subtime

SELECT

aa.*, bb.VALUE

FROM

(

SELECT

NAME,

max(time) AS time

FROM

my_test

GROUP BY

NAME

) aa

LEFT JOIN (

SELECT

NAME,

time,

sum(VALUE) AS VALUE

FROM

my_test

GROUP BY

NAME,

time

) bb ON aa. NAME = bb. NAME

AND aa.time = bb.time

ps:写得有点复杂 （my_test 换成你自己的表名）

---