answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
yan
29 days ago
15

Write the UPDATE command to increase the commission (column name :COMM) by 500 of all the salesman who have achieved sales (Colu

mn name : SALES) more than 20000. The table’s name is COMPANY?
Computers and Technology
1 answer:
Rzqust [1K]29 days ago
4 0

Answer:

UPDATE COMPANY

SET COMM=COMM + 500

WHERE SALES> 20000;

Explanation:

The UPDATE statement functions to modify records within the database management system's table. The command serves to alter records based on certain conditions set in the database management system.

The syntax for employing the UPDATE command is as follows:

UPDATE table-name

SET column name 1, column name 2.........

WHERE condition

  • In this particular instance, the table name is "COMPANY" with a condition related to the sales column; it modifies the table when sales exceed 20,000 and increases COMM by 500.
You might be interested in
One example of how psychological research can be used to control harmful behavior would be __________. A. fooling individuals th
Harlamova29_29 [1022]

Psychological research can be misused for harmful reasons like deceiving people through emotions, using propaganda to shift beliefs, or media manipulation.

However, it can also be beneficial, which is the intent of the question. Clearly, from the options presented, only (D) enhancing communication and relationships represents a positive application of psychological research.

8 0
1 month ago
Read 2 more answers
A four-year-old laptop will not boot and presents error messages on screen. You have verified with the laptop technical support
8_murik_8 [964]
Consider whether the laptop is worth fixing. If it is, proceed with the repair, and if it isn’t, you know the next steps.
7 0
2 months ago
Given the plaintext {0F0E0D0C0B0A09080706050403020100} and the key {02020202020202020202020202020202}: a. Show the original cont
zubka84 [1067]

Answer:

Refer to the explanation.

Explanation:

We will organize the plaintext into a 4 x 4 matrix (a rectangular array of symbols, numbers, or expressions arranged in columns and rows, in this case, a 4 × 4 configuration with four rows and four columns.) as detailed in the step-by-step explanation below.

5 0
2 months ago
Kim's father's company has expanded many times. Therefore, the company's volume of data has also increased. The employees of tha
maria [1035]

B. LAN


LAN is the preferred choice as it is secured and wired. The transfer of large data volumes over LAN is more efficient than WLAN, making it the ideal solution for employees needing quick access to substantial data.

4 0
2 months ago
Read 2 more answers
Key Categories: more libraries and thousands of functions
zubka84 [1067]
2b2t. Explanation: 2b2t.
6 0
1 month ago
Other questions:
  • Why were the practitioners of alternative software development methods not satisfied with the traditional waterfall method?
    9·1 answer
  • Ajay wants to read a brief overview about early settlers in the United States. Which type of online text source should he most l
    9·2 answers
  • Which type of testing is done when one of your existing functions stop working?
    11·1 answer
  • Henry, a graphic artist, wants to create posters. Which software should Henry use for this purpose?
    13·1 answer
  • Write a loop to populate the list user_guesses with a number of guesses. The variable num_guesses is the number of guesses the u
    13·1 answer
  • When adopting and implementing a Software as a Service (SaaS) platform such as Salesforce for your business, which responsibilit
    7·1 answer
  • What term best describes the grammatical rules for writing proper code? paths syntax hyperlinks declarations
    7·2 answers
  • Anna is making a presentation on the top five most visited cities in her state. she wants to make sure that she does not put in
    11·2 answers
  • Write a function in the cell below that iterates through the words in file_contents, removes punctuation, and counts the frequen
    6·1 answer
  • The geographic coordinate system is used to represent any location on Earth as a combination of latitude and longitude values. T
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!