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.
Questo esercizio fa parte del corso
Transactions and Error Handling in PostgreSQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- 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;