Quote Originally Posted by abhu_05
hi i m working in oracle8i sql plus i have one sql querry but it is not executing instead givivng msg that
1* create table totals as select rno,sum(mark) from marks group by rno

and system gives message that

create table totals as select rno,sum(mark) from marks group by rno
*
ERROR at line 1:
ORA-00998: must name this expression with a column alias

so solve my doubt plzzzzzzz
whether my querry is wrong?????????
or not?
plz help me i have to create secondary table
ragrds
abhinav pandey
hello friend,
actually you gave sum(mark) group function. but near the word group you can add the letter s as 'marks'
i think the following query can be working.
create table totals as select rno,sum(marks) from marks group by rno