X Transaction 2 Time 1 Transaction 1 SELECT Pts INTO :p1 FROM Students WHERE Sid=789; 2 SELECT Pts INTO :points FROM Stu
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
X Transaction 2 Time 1 Transaction 1 SELECT Pts INTO :p1 FROM Students WHERE Sid=789; 2 SELECT Pts INTO :points FROM Stu
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?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!