Page 1 of 1
X Transaction 2 Time 1 Transaction 1 SELECT Pts INTO :p1 FROM Students WHERE Sid=789; 2 SELECT Pts INTO :points FROM Stu
Posted: Mon May 09, 2022 6:25 am
by answerhappygod
- X Transaction 2 Time 1 Transaction 1 Select Pts Into P1 From Students Where Sid 789 2 Select Pts Into Points From Stu 1 (81.73 KiB) Viewed 20 times
X Transaction 2 Time 1 Transaction 1 SELECT Pts INTO :p1 FROM Students WHERE Sid=789; 2 SELECT Pts INTO :points FROM Students WHERE Sid=789; points += 23.5; 3 4 5 points += 24.0; UPDATE Students SET Pts=:points WHERE Sid=789; COMMIT TRANSACTION; COIN 6 7 UPDATE Students SET Pts=:points WHERE Sid=789; COMMIT TRANSACTION; 8 What is the difference in Pts between time points 8 and 1?