【数据透视表中级201301班】D组-第二讲作业上交贴（已开贴）

Laphe

1. select 产品码 from [订单$]

复制代码

1. select top 20 * from [订单$] where 客户 like "鑫豪专卖店" order by 订单数量 desc

复制代码

1. select top 10 * from [订单$] where 款号 like "%L%" and 订单数量>2000 order by 订单数量

复制代码

1. select 客户,工单号,订单数量,订单交期 from [订单$] where 订单交期 between   #2011-1-1# and #2011-6-30# and 客户 in ("火狐野营","昆明人在旅途","徐州火凤凰户外运动","卡迪克公司") and 工单号 like "[!A-B]%"

复制代码

1. select * from [订单$]   where 订单交期 between #2011-7-1# and #2011-12-31# and [ERP CO号] like "%001" and 订单数量 >=1000 and 订单数量 <2000

复制代码

1. select 产品码,sum(订单数量) as 订单量 from [订单$] where 订单数量>5000   group by 产品码  order by sum(订单数量)

复制代码

1. select 工单号,count(*) as 订单次数,sum(订单数量) as 订单合计数   from [订单$]   group by 工单号

复制代码