For example, you could use this expression to give employees a $1,000 holiday bonus: set salary=salary + 1000. If you omit the WHERE clause, all the rows are updated. When you use a WHERE clause, only ...

As we saw in the last article, the SQL SELECT statement has the widest variety of query options, ... In the following example, only rows in which the net_amount is greater than 100 will be returned.