The correct SQL code to complete the task of giving all staff a 2% salary increase is __.单项选择题

A

UPDATE Staff, SET salary = salary*2%

B

UPDATE Staff, SET salary = salary+2%

C

UPDATE Staff, SET salary = salary*1.02

D

UPDATE Staff, SET salary = salary+1.02

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

Candy Database            Candy  ( CandyType char(15),                Cost dec(9,2),                Colour char(10))   People ( Personname char(20),                Age smallint,               Suburb char(20),                  PhoneNumber char(10))   Likes   ( Personname char(20),               CandyType char(15))   Choose the SQL query that will answer the following question using the Candy Database. Update the cost of candy by an additional $2.50, where the last part of the name is the word Nougat ?  

Candy Database            Candy  ( CandyType char(15),                Cost dec(9,2),                Colour char(10))   People ( Personname char(20),                Age smallint,                  Suburb char(20),                  PhoneNumber char(10))   Likes   ( Personname char(20),               CandyType char(15))   Choose the SQL query that will answer the following question using the Candy Database. Update the cost of candy by reducing $1.50, where the first part of the name is the word Caramel ?

What happens if you omit the WHERE clause in an UPDATE statement?

Which of the following statements regarding the UPDATE command is not correct?​

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！