Informatics Practices
Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who have achieved Sales (Column name : SALES) more than 200000. The table's name is COMPANY.
SQL Queries
1 Like
Answer
UPDATE COMPANY
SET COMM = COMM + 500
WHERE SALES > 200000;
Answered By
1 Like