$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #26

What does the final SELECT return?

-- acct: id 1, bal 100
BEGIN;
UPDATE acct SET bal = bal - 50
  WHERE id = 1;
ROLLBACK;
SELECT bal FROM acct WHERE id = 1;
  1. 150
  2. 100
  3. 50
  4. NULL
ROLLBACK undoes everything since BEGIN, so the balance is still 100.
Play SQL & Databases ▸