课程号; WHERE 选课.成绩>=70 GROUP BY 学生. HAVING COUNT(选课.课程号)>3 ____________________________________________________________________________ PUBLIC A(3),i A(1)=3000 A(2)=4000 A(3)=5000
IF THISFORM.Optiongroup1.OPTION1.VALUE=1 FOR i=1 TO 3 IF THISFORM.COMBO1.LISTINDEX=I THEN SELECT * FROM 教师表 ORDER BY 工资 DESC, INTO TABLE SALARY WHERE 教师表.工资>=a(i) ENDIF NEXT ELSE FOR I=1 TO 3 IF THISFORM.COMBO1.LISTINDEX=I THEN SELECT * FROM 教师表 ORDER BY 工资 DESC, INTO TABLE SALARY WHERE 教师表.工资
NEXT ENDIF
0000000000000000000000000000000000000000000000000000000000000000 SELECT ORDERITEM.商品号,orderitem.数量; from order JOIN orderitem; ON ORDER.订单号=orderitem.订单号; WHERE year(ORDER.签订日期)=2001 into table TEM SELECT GOODS.商品名,SUM(GOODS.单价*TEM.数量) as 总金额 FROM GOODS LEFT OUTER JOIN TEM; GROUP BY GOODS.商品名; ORDER BY GOODS.商品名; INTO TABLE THREE DO WHILE NOT EOF() IF 总金额 ISNULL REPLACE 总金额 WITH 0 SKIP ENDIF ENDDO
_______________________________________________________________ DO CASE CASE THISFORM.Optiongroup1.Option.VALUE=1 USE SVIEW BROW SELECT * FROM SVIEW INTO TABLE GZ1.DBF CASE THISFORM.Optiongroup1.Option2.VALUE=1 USE DEPT BROW SELECT 部门号,部门名 FROM DEPT INTO TABLE BM1.DBF CASE THISFORM.Optiongroup1.Option3.VALUE=1 SELECT dept.部门号,salaryS.雇员号,SUM(SALARYS.工资) AS 工资,sum(SALARYS.补 贴 ) as 补 贴 ,SUM(SALARYS. 奖 励 ) AS 奖 励 ,SUM(SALARYS. 失 业 保 险 ) AS 失 业 保 险,SUM(SALARYS.医疗统筹) AS 医疗统筹; FROM ASLARYS,DEPT where SALARYS.部门号=DEPT.部门号; GROUP BY 1; ORDER BY 1 INTO TABLE HZ1.DBF
ENDCASE
select 学生.,学生.,AVG(选课.成绩) AS 平均分,COUNT(选课.课程号) AS 选课门 数; FROM 选课 JOIN 学生; ON 选课.=学生.; GROUP BY 学生.; HAVING COUNT(选课.课程号)>=5; ORDER BY 平均分 DESC INTO TABLE STU_TEMP
标签移动 时钟代码 IF THISFORM.Label1.LEFT + THISFORM.Label1.WIDTH<0 THISFORM.Label1.LEFT = THISFORM.WIDTH ELSE THISFORM.Label1.LEFT = TH
ISFORM.Label1.LEFT-10 ENDIF
_____________________________________________________________________________ SET TALK ON SET SAFETY ON SELECT 订号单,SUM(单价*数量) AS 总金额; FROM ORDER_DETAIL; GROUP BY 订单号; into table CURTABLE &;&; 首先应该得到每一订单的总金额 SELECT ORDER_LIST.*; FROM ORDER_LIST,CURTABLE
&;&;临时表
where ORDER_LIST.订单号=CURTABLE.订单号 AND ORDER_LIST.总金额<>CURTABLE. 总金额; into table OD_MOD &;&;根据上面所得到的临时表中每一订单的总金额来得到 ORDER_LIST 中不正确的记录 use OD_MOD DO WHILE NOT EOF()&;&;遍历 OD)MOD 中的每一条记录 SELECT CURTABLE.总金额 FROM CURTABLE; WHERE CURTABLE.订单号=OD_MOD.订单号; INTO ARRAY AFIELDSVALUE &;&;从临时表 CURTABLE 中得到与当前记录的订单号相同的订单的正确的总金额 skip ENDDO CLOSE ALL SELECT * FROM OD_MOD ORDER BY 总金额; INTO CURSOR CURTABLE &;&;生成一个临时表 &;&;再从蓝色表生成表,并覆盖原表 SELECT * FROM CURTABLE INTO TABLE OD_MOD SET TALK OFF SET SAFETY OFF _______________________________________________________________________________ __ SELECT STUDENT.,STUDENT.,AVG(SC.成绩) AS 平均成绩,MIN(SC.成绩) AS 最 低分; from SDB!STUDENT JOIN SDB!SC; ON STUDENT.=SC.; GROUP BY 1 HAVING SC.成绩 >=60 order by 1 INTO TABLE FOUR
__________________________________________________________ 使用 SQL 语句查询每个职工号所经手的具有最高金额的订购单信息 (ORDERS)并将结果按金额升序、金额相同订购单号升序存储到表 select * from orders order by 金额,订购单号 WHERE 职工号+STR(金额,10,0) IN ; (SELECT 职工号+STR(MAX(ORDERS.金额),10,0) from ORDERS GROUP BY 职工号); INTO TABLE RESULTS
__________________________________________________
建立视图 VIEW_B 视图中是目前在 orderS 表中没有所签订单的职工 (EMPLOYEE )信息 create VIEW VIEW_B AS; SELECT * FROM EMPLOYEE WHERE NOT IN; (SELECT 职工号 FROM orders) ORDER BY 仓库号 DESC
CREATE TABLE 销售明细表(顺序号 C(6) PRIMARY KEY ,日期 D(4),商品号 C(6), 商品名 C(10), 金额 N(10,2))
----------------------------------------SELECT MONTH(签订日期) AS 月份,COUNT(订单号) AS 订单数 FROM ORDERS; WHERE YEAR(签订日期)=2007 group by 1 order by 1 into table tableone
-------------------------------------------IF THISFORM.Optiongroup1.Option1.VALUE=1 SELECT 职 工 号 , 系 号 , 姓 名 , 工 资 , 课 程 号 from 教 师 表 WHERE 工 资>=VAL(