First page Back Continue Last page Overview Graphics
Delete Update Queries
DELETE FROM Students S WHERE S.name = `Smith‘
UPDATE Students S SET S.age = S.age + 1, S.gpa = S.gpa – 1 WHERE S.sid = 53688
UPDATE Students S SET S.gpa = S.gpa - 0.1 WHERE S.gpa >= 3.3