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.
This exercise is part of the course
Transactions and Error Handling in PostgreSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- 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;