17,377
社区成员
发帖
与我相关
我的任务
分享
select sum(money)
from tb t1, (select min(thetime) min_dt from tb group by to_char(thetime,'yyyymm')) t2
where t1.thetime between t2.min_dt and last_day(t2.min_dt) ;
SELECT TO_CHAR(thetime,'YYYY-MM-DD'),SUM(MONEY) totalmoney
FROM T
WHERE TO_CHAR(thetime,'YYYYMM')=(SELECT TO_CHAR(MIN(thetime),'YYYYMM') FROM T)
group by TO_CHAR(thetime,'YYYY-MM-DD')
ORDER BY TO_CHAR(thetime,'YYYY-MM-DD')
SELECT SUM(MONEY) totalmoney
FROM T
WHERE TO_CHAR(thetime,'YYYYMM')=(SELECT TO_CHAR(MIN(thetime),'YYYYMM') FROM T)
[/quote]
这个SQL 只能统计一条数据 ,不能统计 26 日至 30 日之和 啊 。。
select sum(money)
from tb t1, (select min(thetime) min_dt from tb) t2
where t1.thetime between t2.min_dt and last_day(t2.min_dt)
[/quote]
如果时间字段带小时分秒的话这么写有点问题,最后一天可能有部分统计不进来
select sum(money)
from tb t1, (select min(thetime) min_dt from tb) t2
where t1.thetime between t2.min_dt and last_day(t2.min_dt)
SELECT SUM(MONEY) totalmoney
FROM T
WHERE TO_CHAR(thetime,'YYYYMM')=(SELECT TO_CHAR(MIN(thetime),'YYYYMM') FROM T)