Update Query

Q:4
Update field total with the sum of Sub1, Sub2 and Sub3.


SQL> UPDATE STUDENT SET TOTAL=SUB1+SUB2+SUB3;

6 rows updated.