SQL-aggregate function [message #274665] |
Tue, 16 October 2007 14:39 |
amitdumbre27
Messages: 4 Registered: October 2007 Location: mumbai
|
Junior Member |
|
|
I want to show the total of all subjects in a separate column(total) according to student, in short i want to feel the total column. Please help me out for the SQL quiry
SQL> select * from student;
ROLL_NO NAME MATHS SCIENCE ENGLISH TOTAL
---------- --------- ---------- ---------- ------- ---------
1 amit 80 85 90
2 nitin 60 65 80
3 arasan 70 75 85
4 avi 60 65 75
[mod-edit]Added code tags.
[Updated on: Wed, 17 October 2007 00:53] by Moderator Report message to a moderator
|
|
|
|
|
|