单项选择题

A．SELECT * TOP 3 FROM Employee INTO FILE Em_text ORDER ……

将表结构为（职工号，姓名，工资）的表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

<上一题目录下一题>

热门试题

单项选择题建立表Employee的视图Em_view，正确的SQL命令是

A．CREATE VIEW Em_view WHLIE SELECT 职工号,工资 FROM Employee
B．CREATE AS Em_view VIEW SELECT 职工号,工资 FROM Employee
C．CREATE VIEW Em_view AS SELECT 职工号,工资 FROM Employee
D．CREATE VIEW Em_view SELECT 职工号,工资 FROM Employee

单项选择题有表名为Employee的表结构（职工号，姓名，工资），为表Employee增加字段住址的SQL命令是

A．ALTER DBF Employee ADD 住址 C(30)
B．CHANGE DBF Employee ADD 住址 C(30)
C．CHANGE TABLE Employee ADD 住址 C(30)
D．ALTER TABLE Employee ADD 住址 C(30)