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

[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"