SQL Lab Exercises-2 Table creation Show Structure Record Insertion Update Query SELECT with MAX() SELECT with ORDER BY SELECT with MAX() Nested Query SELECT Query SELECT with AVG()


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.