Skip to Content
0
Former Member
Nov 29, 2006 at 04:44 AM

finding the total of a row

26 Views

Hi!

Ca someone help me in writing an open sql stmt for adding the values in a row and finding the total?

for eg consider the following table:

STUDENT SUB1 SUB2 SUB3 TOTAL

-


AAA 45 76 86

I want to add sub1,sub2 and sub3 for that record and find the total.

Thanks.

Srikanth.