This command updates values in the table 'person'. Small negative accounts are set to 0.
UPDATE person SET account = 0
WHERE account > -10 AND
account <= 0
SELECT cno, firstname, name, account
FROM person
Note that all rows of the table are updated when a WHERE condition is missing.
The general format of the UPDATE statement is:
UPDATE..... table name
SET........ modification of the column values
WHERE...... which rows