现有订单表orders,包含字段:订单号order__idvarchar(10),产品编号p__idvarchar(10),产品类型typevarchar(20),金额amountdecimal(10,2)。(1)以下表名orders和字段名amount的使用,正确的是()
A.orders.amount
B.orders_amount
C.orders$amount
D.orders[amount]
A.orders.amount
B.orders_amount
C.orders$amount
D.orders[amount]
设有订单表order(其中包含字段:订单号,客户号,职员号,签订日期,金额),删除2002年1月1日以前签订的订单记录,正确的SQL命令是()。
A.DELETE TABLE order WHERE签订日期<{^2002-1-1}
B.DELETE TABLE order WHILE签订日期<{^2002-1-1}
C.DELETE FROM order WHERE签订日期<{^2002-1-1}
D.DELETE FROM order WHILE签订日期<{^2002-1-1}
A、select productid from orders where count (productid)>1
B、select productid from orders where max (productid)>1
C、select productid from orders where having count(productid)>1 group by productid
D、select productid from orders group by productid having count(productid)>1
A.selectdistinct(cid)fromorderso1whereo1.pidin('p01','p02')
B.selectdistinct(cid)fromorderso1,orderso2whereo1.pid='p01'ando2.pid='p02'ando1.cid=o2.cid
C.selectdistinct(cid)fromorderso1wherepid='p01'andcidin(selectcidfromorderswherepid='p02')
D.electdistinct(cid)fromorderso1,orderso2whereo1.pid='p01'ando2.pid='p02'
A) SELECT * FROM order WHERE YEAR(签订日期 )=2007 ORDER BY 金额 DESC
B) SELECT * FROM order WHILE YEAR(签订日期 )=2007 ORDER BY 金额 ASC
C) SELECT * FROM order WHERE YEAR(签订日期 )=2007 ORDER BY 金额 ASC
D) SELECT * FROM order WHILE YEAR(签订日期 )=2007 ORDER BY 金额 DESC
A.SELECT c_customer,SUM(c_price)FROM c_orders GROUP BY c_customer
B.SELECT c_customer,SUM(c_price)FROM c_orders GROUP BY c_id
C.SELECT c_customer,COUNT(c_price)FROM c_orders GROUP BY c_customer
D.SELECT c_customer,SUM(c_price)FROM c_orders Order BY c_customer
A.DELETETABLEorderWHERE签订日期<{^2002-1-1}
B.DELETETABLEorderWHILE签订日期>{^2002-1-1}
C.DELETEFROMorderWHERE签订日期<{^2002-1-1}
D.DELETEFROMorderWHILE签订日期>{^2002-1-1}
A.DELETETABLEorderWHERE签订日期<{^2002-1-1}
B.deletetableorderwhile签订日期>{^2002-1-1}
C.DELETEFROMorderWHERE签订日期<{^2002-1-1}
D.deletefromorderwhile签订日期>{^2002-1-1}
A.SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)>3 AND AVG金额>200
B.SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)>3 AND AVG(金额)>200
C.SELECT职员号FROM订单 GROUP BY职员号HAVING COUNT(*)>3WHERE AVG(金额)>200
D.SELECT职员号FROM订单 GROUP BY职员号WHERE COUNT(*)>3AND AVG金额>200
综合题设计数据库某仓库管理系统中,现有如下表格
(1)图书表
(2)借阅登记
要求:
1、用ACCESS设计存放客户信息和报名情况的表,包括:
(1)表名
(2)表包含的字段和字段名
(3)各字段的数据类型
(4)哪个字段作为表的主键。
2、说明这两个表的关系。