数据库系统原理精品课件（康辉）ch3-kh.pptVIP

Modification of the Database – Deletion Delete all account tuples at the Perryridge branch delete from account where branch_name = Perryridge Delete all accounts at every branch located in the city ‘Needham’. delete from accountwhere branch_name in (select branch_name from branch where branch_city = Needham)  Example Query Delete the record of all accounts with balances below the average at the bank. delete from account where balance (select avg (balance ) from account ) Problem: as we delete tuples from de