group by
clause causes the error ORA-00937: not a single-group group function to be thrown. (but compare with ORA-00979: not a GROUP BY expression). create table tq84_tab ( num number, txt varchar2(10) );
select sum(num) sum_num, txt from tq84_tab;
select sum(num) sum_num, txt from tq84_tab group by txt;
drop table tq84_tab;