SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to calculate the average of columns row wiise?

534835Feb 8 2008 — edited Feb 9 2008

i have the database containing columns related to internal marks and final marks..
here I1,I2 stands for internal marks and E stands for external marks for the subject..
Now tell me is there any way of calculating the average of internal marks per subject per student and retrieivng external marks (E) in a single query.. i.e. (i1+I2+I3+I4)/4 and E

I1 I2 I3 I4 E sub rollno
---- ---------- ---------- ---------- -------------- ------- -------
19 8 17 15 75 eng 100
0 45 3 5 60 math 100
0 0 5 10 40 phy 100

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2008

Added on Feb 8 2008

3 comments

645 views