Code
UPDATE Math_Results
SET Marks=80
WHERE marks=79;
EXPLANATION
This update query will update the table Math_Results and set the marks of all students to 80 who secured 79 marks.
Say Bye to Bugs
UPDATE Math_Results
SET Marks=80
WHERE marks=79;
This update query will update the table Math_Results and set the marks of all students to 80 who secured 79 marks.
Leave a comment