单项选择题

将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"

<上一题目录下一题>

热门试题

单项选择题

删除表Em_temp 的SQL语句是

A．DROP TABLE Em_temp
B．DELETE TABLE Em_temp
C．DROP FILE Em_temp
D．DELETE FILE Em_temp

单项选择题

将表结构为（职工号，姓名，工资）的表Employee中工资最多的前3名记录存储到文本文件Em_text，正确的SQL命令是

A．SELECT * TOP 3 FROM Employee INTO FILE Em_text ORDER BY 工资
B．SELECT * TOP 3 FROM Employee TO FILE Em_text ORDER BY 工资
C．SELECT * TOP 3 FROM Employee INTO FILE Em_text ORDER BY 工资 DESC
D．SELECT * TOP 3 FROM Employee TO FILE Em_text ORDER BY 工资 DESC