帮忙解决oracle的sql语句错误

waitingfly

帮帮忙：

  1  select
  2  to_char(EndTime,'yyyy.mm.dd hh24:mi') Time,
  3  sum(Octets)/1048576 FlowIn,
  4  sum(Packets) PacketIn,
  5  avg((8*sum(Octets)/1048576)/((EndTime-StartTime)*86400)) SFlowIn
  6  from AsMatrix
  7  where RouterIP='192.168.0.216'
  8  and InputIfIndex=11
  9  and EndTime >;= to_date('2004-1-15','yyyy-mm-dd hh24:mi:ss')
10  and EndTime < to_date('2004-1-15 10:40','yyyy-mm-dd hh24:mi:ss')
11* group by EndTime
to_char(EndTime,'yyyy.mm.dd hh24:mi') Time,
        *
ERROR at line 2:
ORA-00937: not a single-group group function

wind0299

group by EndTime
->;
group by Time

waitingfly

谢谢
group 别名Time，不行

wind0299

我是新手，别怪我
那就写全名

waitingfly

呵呵，不可以。全名、新加其他字段，都不可以

zhouok

group by 1