2013计算机二级VF上机备考习题十二(附答案)(2)

  基本操作题答案:

  4、update products set 销售价格=进货价格*(1+18.98/100)

  简单应用题答案:

  1、第一处将“=”改为“in”, 第二处将“*”改为“学号”, 第三处将“学号”改为“课程号”

  综合应用题答案:

  “计算”菜单项的过程代码为:

  SELECT 股票代码,COUNT(*) AS 买入次数,MAX(单价) AS 最高价 FROM STOCK_MM WHERE 买卖标记 GROUP BY 股票代码 ;

  ORDER BY 股票代码 INTO ARRAY aaa

  DELETE FROM STOCK_CS

  INSERT INTO STOCK_CS FROM ARRAY aaa

  SELECT * TOP 1 FROM STOCK_CS ORDER BY 买入次数 DESC INTO TABLE STOCK_X

  “退出”菜单项的命令代码为:set sysmenu to default