I'm assuming you are referring to Excel. There are a few ways to add A1 and B1.
First you could use '=SUM(A1+B1)'
You could also use '=SUM(A1:B1)' which adds the values of all the cells between A1 and B1, but since they are next to each other, this would work.
You could also use '=SUM(A1,B1)' where you list all the cells you want to add with commas in between.
If this is a given definition, the term is "array".
Answer:
UPDATE COMPANY
SET COMM=COMM + 500
WHERE SALES> 20000;
Explanation:
The update command is used for alter the record in the database management system in the table .The update command command modify the record on the some condition in the table in the database management system.
Following are syntax for using the update command .
UPDATE table-name
SET column name 1,column name 2 .........
Where condition
- In the given question table -name is "COMPANY" the condition is on the sales column and it update the table only when sales is more than 20000 and set the column COMM by 500.
