求一个SQL语句的写法!希望大家帮帮忙！

是这样的，现在这边要求就是假如我查询从2012-05-11 号到 2012-05-21 号的数据这中间不是有10天的时间吗？
如果是2012-05-15 号到 2012-05-20 就是 5天的时间我需要把每天的数据做个汇总，就是这样按照收货单位，发货单位，物料，
比如物料:铁块把然后发货:邯郸，收货:北京就按照这个信息把他从2012-05-11 这1天的产量汇总起来，中间有重量就是算出每1天的产量，
这1天拉了多少货物,多少重量.
2012-05-12 这1天还汇总起来
就是一直汇总到2012-05-21 但是中间的每一天数据量都要汇总表结构就是一张表的数据进行汇总按照这个创建时间来的
这个SQL语句怎么写啊。。想了好半天了，希望大家帮帮忙！

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

表结构很简单就是一张表，创建日期，收货单位，发货单位，重量，物料名称净重时间
查询条件是根据净重时间去查的，开始时间2012-05-11 ，结束时间是2012-05-21
查这10天的数据显示如下比如   收货单位发货单位   重量  物料名称   净重时间
       北京       邯郸     20.52 钢铁     2012-05-11
      北京       邯郸     30    钢铁     2012-05-12
      北京       邯郸     40    钢铁     2012-05-13
      北京       邯郸     50    钢铁     2012-05-14表名叫m_measure_t   收货单位 targetname    发货单位 sourcename  重量 weight 物料名称 materialname 净重时间 suttletime
重量是这1天的累加和
就是列出这10天的每天的产量就是重量那个字段
上面的结果我说的还不清楚吗？就是求一个这样的SQL语句oracle的，表里面就那几个字段我还怎么列表那?
帮帮好吗？肯定给结贴的，我至于吗。。真心来求助的2个人问我结贴率
select sum(重量) from m_measure_t group by cube(suttletime) 你试一下这个
有这么多废话功夫把建表语句写出来，要不给你写什么SQL？没表名没字段名你能看得懂吗？一个grouping sets就解决的问题，说得够清楚不？你能写出来吗？
如果这么简单就好了。。
不太行我把表结构贴出来吧,
-- Create table
create table M_MEASURE_T
(
  MATCHID             VARCHAR2(20) not null,
  ICNO                VARCHAR2(16),
  CARNO               VARCHAR2(30),
  CARTYPE             CHAR(1),
  OPERATYPE           NUMBER default 0,
  TASKCODE            VARCHAR2(10),
  PLANID              VARCHAR2(40),
  ORDERNO             VARCHAR2(40),
  MATERIALCODE        VARCHAR2(40),
  MATERIALNAME        VARCHAR2(300),
  MATERIALSPECCODE    VARCHAR2(40),
  MATERIALSPEC        VARCHAR2(300),
  SOURCECODE          VARCHAR2(40),
  SOURCENAME          VARCHAR2(300),
  TARGETCODE          VARCHAR2(40),
  TARGETNAME          VARCHAR2(300),
  BASKET              VARCHAR2(40),
  MATERIALCOUNT       NUMBER default 0,
  GROSSLOGID          VARCHAR2(20),
  GROSS               NUMBER(10,3) default 0,
  GROSSTIME           DATE,
  GROSSWEIGHID        VARCHAR2(20),
  GROSSWEIGH          VARCHAR2(50),
  GROSSWEIGHGROUP     VARCHAR2(10),
  GROSSOPERATORID     VARCHAR2(40),
  GROSSOPERATOR       VARCHAR2(50),
  GROSSGROUPNO        NUMBER,
  GROSSSERIAL         NUMBER,
  TARELOGID           VARCHAR2(20),
  TARE                NUMBER(10,3) default 0,
  TARETIME            DATE,
  TAREWEIGHID         VARCHAR2(20),
  TAREWEIGH           VARCHAR2(50),
  TAREWEIGHGROUP      VARCHAR2(10),
  TAREOPERATORID      VARCHAR2(40),
  TAREOPERATOR        VARCHAR2(50),
  TAREGROUPNO         NUMBER,
  TARESERIAL          NUMBER,
  DEDUCTION           NUMBER(10,3) default 0,
  DEDUCTIONTIME       DATE,
  DEDUCTIONUNIT       VARCHAR2(300),
  DEDUCTIONOPERATORID VARCHAR2(40),
  DEDUCTIONOPERATOR   VARCHAR2(50),
  SUTTLE              NUMBER(10,3) default 0,
  SUTTLETIME          DATE,
  SUTTLEWEIGHID       VARCHAR2(20),
  SUTTLEWEIGH         VARCHAR2(50),
  SUTTLEWEIGHGROUP    VARCHAR2(10),
  SUTTLEOPERATORID    VARCHAR2(40),
  SUTTLEOPERATOR      VARCHAR2(50),
  BMATCHID            VARCHAR2(20),
  BGROSS              NUMBER(10,3) default 0,
  BTARE               NUMBER(10,3) default 0,
  BSUTTLE             NUMBER(10,3) default 0,
  PRINTNUM            NUMBER default 0,
  MSRMEMO             VARCHAR2(1000),
  SYSMEMO             VARCHAR2(1000),
  VALIDFLAG           NUMBER default 1,
  VALIDFLAGTIME       DATE,
  VALIDFLAGOPERATOR   VARCHAR2(50),
  CREATEDATE          DATE default sysdate,
  RECORDTYPE          NUMBER default 0,
  TCODE               VARCHAR2(20),
  TNAME               VARCHAR2(300),
  CLIENTID            VARCHAR2(20),
  SHIPCODE            VARCHAR2(40),
  SHIP                VARCHAR2(100),
  HEATNO              VARCHAR2(50),
  STEELSIZE           VARCHAR2(50),
  ADDTIME             DATE default sysdate,
  UPTIMESTAMP         TIMESTAMP(6),
  UPTIME              DATE
)
tablespace LESDATA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table
comment on table M_MEASURE_T
  is '计量表 ';
-- Add comments to the columns
comment on column M_MEASURE_T.MATCHID
  is '验配ID
终端ID（3位）+年年+月月+日日+5位流水号（+一车多货流水号）
服务器终端编号000
预留4位以后扩展
正常流程此ID与进厂刷卡时生成的ID关联';
comment on column M_MEASURE_T.ICNO
  is 'ic卡号';
comment on column M_MEASURE_T.CARNO
  is '车号';
comment on column M_MEASURE_T.CARTYPE
  is '车辆类型 C， T';
comment on column M_MEASURE_T.OPERATYPE
  is '  0-厂内调拨
comment on column M_MEASURE_T.TASKCODE
  is '业务号';
comment on column M_MEASURE_T.PLANID
  is '计划号,备用';
comment on column M_MEASURE_T.ORDERNO
  is '订单号,备用';
comment on column M_MEASURE_T.MATERIALCODE
  is '物料编码';
comment on column M_MEASURE_T.MATERIALNAME
  is '物料名称';
comment on column M_MEASURE_T.MATERIALSPECCODE
  is '物料规格编码';
comment on column M_MEASURE_T.MATERIALSPEC
  is '物料规格';
comment on column M_MEASURE_T.SOURCECODE
  is '来源编码';
comment on column M_MEASURE_T.SOURCENAME
  is '来源名称';
comment on column M_MEASURE_T.TARGETCODE
  is '去向编码';
comment on column M_MEASURE_T.TARGETNAME
  is '去向名称';
comment on column M_MEASURE_T.BASKET
  is '发站';
comment on column M_MEASURE_T.MATERIALCOUNT
  is '物料支数';
comment on column M_MEASURE_T.GROSSLOGID
  is '计量毛日志id';
comment on column M_MEASURE_T.GROSS
  is '毛重';
comment on column M_MEASURE_T.GROSSTIME
  is '毛重时间';
comment on column M_MEASURE_T.GROSSWEIGHID
  is '毛重衡器id';
comment on column M_MEASURE_T.GROSSWEIGH
  is '毛重衡器';
comment on column M_MEASURE_T.GROSSWEIGHGROUP
  is '毛重衡器组号';
comment on column M_MEASURE_T.GROSSOPERATORID
  is '毛重计量员编码';
comment on column M_MEASURE_T.GROSSOPERATOR
  is '毛重计量员';
comment on column M_MEASURE_T.GROSSGROUPNO
  is '毛重列号';
comment on column M_MEASURE_T.GROSSSERIAL
  is '毛重序号';
comment on column M_MEASURE_T.TARELOGID
  is '计量皮日志ID';
comment on column M_MEASURE_T.TARE
  is '皮重';
comment on column M_MEASURE_T.TARETIME
  is '皮重时间';
comment on column M_MEASURE_T.TAREWEIGHID
  is '皮重衡器id';
comment on column M_MEASURE_T.TAREWEIGH
  is '皮重衡器';
comment on column M_MEASURE_T.TAREWEIGHGROUP
  is '皮重衡器组号';
comment on column M_MEASURE_T.TAREOPERATORID
  is '皮重计量员编码';
comment on column M_MEASURE_T.TAREOPERATOR
  is '皮重计量员';
comment on column M_MEASURE_T.TAREGROUPNO
  is '皮重列号';
comment on column M_MEASURE_T.TARESERIAL
  is '皮重序号';
comment on column M_MEASURE_T.DEDUCTION
  is '总扣重';
comment on column M_MEASURE_T.DEDUCTIONTIME
  is '扣重时间';
comment on column M_MEASURE_T.DEDUCTIONUNIT
  is '扣重单位';
comment on column M_MEASURE_T.DEDUCTIONOPERATORID
  is '扣重人编码';
comment on column M_MEASURE_T.DEDUCTIONOPERATOR
  is '扣重人';
comment on column M_MEASURE_T.SUTTLE
  is '净重';
comment on column M_MEASURE_T.SUTTLETIME
  is '净重时间';
comment on column M_MEASURE_T.SUTTLEWEIGHID
  is '净重衡器id';
comment on column M_MEASURE_T.SUTTLEWEIGH
  is '净重衡器';
comment on column M_MEASURE_T.SUTTLEWEIGHGROUP
  is '净重衡器组号';
comment on column M_MEASURE_T.SUTTLEOPERATORID
  is '净重计量员编码';
comment on column M_MEASURE_T.SUTTLEOPERATOR
  is '净重计量员';
comment on column M_MEASURE_T.BMATCHID
  is '前计量记录ID';
comment on column M_MEASURE_T.BGROSS
  is '前毛重';
comment on column M_MEASURE_T.BTARE
  is '前皮重';
comment on column M_MEASURE_T.BSUTTLE
  is '前净重';
comment on column M_MEASURE_T.PRINTNUM
  is '打印票据';
comment on column M_MEASURE_T.MSRMEMO
  is '计量员录入备注';
comment on column M_MEASURE_T.SYSMEMO
  is '系统备注';
comment on column M_MEASURE_T.VALIDFLAG
  is '是否作废 0 作废 1正常';
comment on column M_MEASURE_T.VALIDFLAGTIME
  is '作废时间';
comment on column M_MEASURE_T.VALIDFLAGOPERATOR
  is '作废人';
comment on column M_MEASURE_T.CREATEDATE
  is '记录添加时间';
comment on column M_MEASURE_T.RECORDTYPE
  is '记录类型  0 自动 1 远程手动  2 异常维护';
comment on column M_MEASURE_T.TCODE
  is '运输单位编码';
comment on column M_MEASURE_T.TNAME
  is '运输单位名称';
comment on column M_MEASURE_T.CLIENTID
  is '终端ID';
comment on column M_MEASURE_T.SHIPCODE
  is '船名编码';
comment on column M_MEASURE_T.SHIP
  is '船名';
comment on column M_MEASURE_T.HEATNO
  is '炉号，连铸坯';
comment on column M_MEASURE_T.STEELSIZE
  is '钢号，连铸坯';
-- Create/Recreate primary, unique and foreign key constraints
alter table M_MEASURE_T
  add constraint MATCHID_PRIMARY primary key (MATCHID)
  using index
  tablespace LESINDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create index IDX_M_MEASURE_T_MATERIALNAME on M_MEASURE_T (MATERIALNAME)
  tablespace LESINDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index MEASURE_CARNO on M_MEASURE_T (CARNO)
  tablespace LESINDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index MEASURE_OPERATYPE on M_MEASURE_T (OPERATYPE)
  tablespace LESINDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index MEASURE_SUTTLETIME on M_MEASURE_T (SUTTLETIME)
  tablespace LESINDEX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Grant/Revoke object privileges
grant select, insert, update, delete on M_MEASURE_T to MFIS_USER;