Single statement transactions
Now you will work with a single statement transaction. Some types of saving accounts hold money that cannot be withdrawn on demand for individuals and corporations. The amount of the heldback money is stored in the RCONB550 field. These types of accounts promote bank stability and generate dependable revenue for the financial institution via fees and loan proceeds. Let's update FIELD48 to be '1' for each of these institutions to signify that they have this stability when it's over $100M.
Diese Übung ist Teil des Kurses
Transactions and Error Handling in PostgreSQL
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Update records to indicate nontransactionals over 100,000,000
UPDATE ffiec_reci
SET ___ = '___'
WHERE RCONB550 > ___;
-- Select a count of records where the flag field is not '1'
SELECT COUNT(*)
FROM ffiec_reci
WHERE ___ != ___ or ___ is null;