help neede in creating new table from another table,plzzzzzzzzz help meeeeeee

[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

[davey23uk]

did you look at the error and do what it tells you?

[thapush]

You need to alias the sum(mark)

create table totals as select rno,sum(mark) mysum from marks group by rno

Notice that "mysum" might not be a good column name for you

[malay_biswal]

I do not see any prob. I created the tavble using this.

SQL> create table b as select rno,sum(mark) mysum from a group by rno;

Table created.

Elapsed: 00:00:00.54

R u sure "rno, mark are 2 column names of mark table"

[PAVB]

You had no problems creating the table 'cause of you used an alias for your sum() column -as thapush advised, while original poster didn't.

[davey23uk]

and it was riased and solved 2 weeks ago, why the need to do re-open it and add nothing useful or insightful (pretty much like the rest of your posts)

[PAVB]

r u talking to me?

#1- It wasn't me the one who re-open the it
#2- I pointed to Malay why he had no issues creating the table

Anything else I can help with?

[davey23uk]

no it wasnt you, it was the other guy

[PAVB]

Fair enough Dave.
The entente cordiale is safe for another hundred years now

[malay_biswal]

I misread the section. Thought it was not resolved yet.