ORA-00979: not a GROUP BY expression when trying to select
506418Jul 26 2006 — edited Jul 26 2006I have such code:
select * from(
select
trunc(cdr_date, :LSTGROUP ) label,
sum(total_calls) data
from stats.cdr_summary@livestats
where cdr_date >=
sysdate - :LSTPERIOD * 1/24
group by trunc(cdr_date, :LSTGROUP )
order by trunc(cdr_date, :LSTGROUP )
)
and received report error:
ORA-00979: not a GROUP BY expression
ORA-02063: preceding line from REALSTATS
Outer select I need in order to have 2 series with order be