单项选择题

将Employee表中职工号为“19620426”的记录中“单位号”修改为“003”正确的SQL语句是

A．UPDATE Employee SET 单位号="003" WHERE 职工号 IS "19620426"
B．UPDATE Employee WHERE 职工号 IS "19620426" SET 单位号="003"
C．UPDATE Employee SET 单位号="003" WHERE 职工号="19620426"
D．UPDATE Employee 单位号 WITH "003" WHERE 职工号="19620426"

<上一题目录下一题>

热门试题

单项选择题删除Employee表中职工号为“19620426”的记录，正确的SQL语句是

A．DELETE FROM Employee WHILE 职工号="19620426"
B．DELETE FOR Employee WHERE 职工号="19620426"
C．DELETE FOR Employee WHILE 职工号="19620426"
D．DELETE FROM Employee WHERE 职工号="19620426"

单项选择题将表结构为(职工号，姓名，工资)的表Employee中所有职工的工资增加20%，正确的SQL命令是

A．CHANGE Employee SET 工资=工资*1.2
B．CHANGE Employee SET 工资 WITH工资*1.2
C．UPDATE Employee SET 工资=工资*1.2
D．UPDATE Employee SET 工资 WITH 工资*1.2