-
be careful
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|