We appreciate your visit to Write the UPDATE command to increase the commission column name COMM by 500 for all the salesmen who have achieved sales column name SALES of. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!
Answer :
The UPDATE command that increases the commission column is: UPDATE COMPANY SET COMM=COMM + 500 WHERE SALES> 20000;
The syntax of an UPDATE SQL command is:
UPDATE table_name SET column = value, where condition
From the question, the table name is COMPANY.
So, we have:
UPDATE COMPANY SET column = value, where condition
The update statement is to increment the COMM column by 500.
So, the query becomes
UPDATE COMPANY SET COMM=COMM + 500 WHERE condition
Lastly, only columns where SALES are greater than 20000 should be updated.
So, the complete command is:
UPDATE COMPANY SET COMM=COMM + 500 WHERE SALES> 20000;
Read more about database at:
https://brainly.com/question/15334693
Thanks for taking the time to read Write the UPDATE command to increase the commission column name COMM by 500 for all the salesmen who have achieved sales column name SALES of. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!
- Why do Businesses Exist Why does Starbucks Exist What Service does Starbucks Provide Really what is their product.
- The pattern of numbers below is an arithmetic sequence tex 14 24 34 44 54 ldots tex Which statement describes the recursive function used to..
- Morgan felt the need to streamline Edison Electric What changes did Morgan make.
Rewritten by : Barada
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.
