如何统计指定时间段内数据！

goodIven

select
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as b,
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as c,
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as d,
from  table  where 工厂='xxxxxxxxxx'
union
select
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as b,
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as c,
(select sum(销售数量) from table group by 工厂,日期 having 日期
between 'xxxxxxxx' and 'xxxxxxxx'   ) as d,
from  table  where 工厂='xxxxxxxxxx'

我没试,你实验看看,日期转换一下汇总到   日  .
慢了点~~~~~~~~~~~~~~~~~

goodIven

不用union 去掉 where 工厂='xxxxxxxxxxx'
好象可以

xtime

select  b.GC_ID,b.Term
                b.Amount as [1-5号],
                c.Amount as [6-10号],
                c.Amount as [11-15号],
                e.Amount as [16-20号],
                f.Amount as [21-25号],
                g.Amount as [26-31号],
                h.Amount as [月汇总]
From
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=0
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=5
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) b,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=6
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=10
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) c,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=11
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=15
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) d,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=16
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=20
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) e,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=21
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=25
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) f,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=26
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=31
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) g,
        (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
                        Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=0
                                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=31
                        Group by GC_ID,DateAdd(Day,1-Day(Date),Date) as Term) h
Where b.GC_ID=c.GC_ID
        and b.GC_ID=d.GC_ID
        and b.GC_ID=e.GC_ID
        and b.GC_ID=f.GC_ID
        and b.GC_ID=g.GC_ID
        and b.GC_ID=g.GC_ID
        and b.Term=c.Term
        and b.Term=d.Term
        and b.Term=e.Term
        and b.Term=f.Term
        and b.Term=g.Term
        and b.Term=h.Term

xtime

上句有错误，更正如下

select  b.GC_ID,b.Term
        b.Amount as [1-5号],
        c.Amount as [6-10号],
        c.Amount as [11-15号],
        e.Amount as [16-20号],
        f.Amount as [21-25号],
        g.Amount as [26-31号],
        h.Amount as [月汇总]
From
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=0
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=5
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))b,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=6
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=10
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))c,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=11
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=15
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))d,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=16
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=20
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))e,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=21
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=25
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))f,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=26
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=31
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))g,
    (select GC_ID,DateAdd(Day,1-Day(Date),Date) as Term,sum(Amount) as Amount from table
            Where Datediff(day,dateadd(day,1-day(Date),Date),date)>=0
                and Datediff(day,dateadd(day,1-day(Date),Date),date)<=31
            Group by GC_ID,DateAdd(Day,1-Day(Date),Date))h
Where b.GC_ID=c.GC_ID
    and b.GC_ID=d.GC_ID
    and b.GC_ID=e.GC_ID
    and b.GC_ID=f.GC_ID
    and b.GC_ID=g.GC_ID
    and b.GC_ID=g.GC_ID
    and b.Term=c.Term
    and b.Term=d.Term
    and b.Term=e.Term
    and b.Term=f.Term
    and b.Term=g.Term
    and b.Term=h.Term