JOIN NOW

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

Related Questions