计算机操作题解析,计算机操作题及解析.doc

计算机操作题及解析

无纸化1.2 (高科28) SELECT 供应.供应商号,供应.工程号,供应.数量;

FROM 零件,供应 WHERE 供应.零件号=零件.零件号;

AND 零件.颜色="红";

ORDER BY 供应.数量 desc;

INTO DBF supply_temp

1.3 Select 零件.零件名,零件.颜色 ,零件.重量;

From 供应,零件;

Where 零件.零件号=供应.零件号 and 供应.工程号=thisform.text1.value;

Order By 零件名;

Into dbf pp

ThisForm.Grid1.RecordSource="pp"

44.1 (22) (1)在命令窗口中分别输入相应命令，并按回车以执行。

① SELECT * FROM stock_sl INTO DBF stock_bk

或 SELECT * FROM stock_sl INTO TABLE stock_bk

② INSERT INTO stock_bk VALUES("600028",4.36,4.60,5500)

③ UPDATE stock_bk SET 现价=8.88 WHERE 股票代码="600007"

④ DELETE FROM stock_bk WHERE 股票代码="600000"

(2)将命令按题目要求复制到sql.txt文件中。

44.3 SET SAFETY OFF

CLOSE DATABASE ALL

SELECT 1

USE stock_Name

INDEX ON 股票代码 TAG dm

SELECT 2

USE stock_sl

INDEX ON 股票代码 TAG dm

SELECT 1

SET RELATION TO 股票代码 INTO stock_sl

ThisForm.grdStock_Name.RECORDSOURCE="stock_Name"

ThisForm.grdStock_Name.REFRESH

ThisForm.grdStock_sl.RECORDSOURCE="stock_sl"

ThisForm.grdStock_sl.REFRESH

SET SAFETY ON

**********************************

步骤4：在"关闭"命令按钮的Click事件代码中输入代码"THISFORM.RELEASE"。

60.2 (92) 步骤4：在"学生表"子菜单的"结果"选择"过程"并输入命令下列语句

SELECT * FROM student

步骤5：在"选课表"子菜单的"结果"选择"过程"并输入命令下列语句

SELECT * FROM sc

步骤6：在"课程表"子菜单的"结果"选择"过程"并输入命令下列语句

SELECT * FROM course

步骤7：在"退出"主菜单的"结果"选择"过程"并输入下列命令 set set sysmenu to default

60.3

SELECT student.学号,姓名,AVG(成绩) AS 平均成绩, COUNT(*) AS 选课门数;

FROM student,sc;

WHERE student.学号=sc.学号;

GROUP BY sc.学号 HAVING COUNT(*)>=4 AND 平均成绩>=75;

ORDER BY 平均成绩 DESC;

INTO dbf two

步骤4：在"表单设计器"中，双击退出命令按钮，在"Command2.Click"编辑窗口中输入"Thisform. Release"，接着关闭编辑窗口

59.2(2) (27) 。第2行改为：SELECT student.学号,姓名,AVG(成绩) 平均成绩,COUNT(成绩) 选课门数;

第3行改为：FROM student JOIN sc ON student.学号 = sc.学号;

第4行改为：WHERE 性别 = "女";

第5行改为：GROUP BY student.学号 HAVING AVG(成绩) >= 75;

修改完成后运行该程序。

59.3 SELECT Student.学号, Student.姓名, AVG(成绩) AS 平均成绩,MIN(成绩) AS 最低分;

FROM sdb!student INNER JOIN sdb!sc ON Student.学号 = Sc.学号;

GROUP BY Student.学号 HAVING MIN(成绩) >=