sql server实验报告

5.查询出职务为职员或职务为科长的女员工的信息

select * from Employee

where sex = 'F' and headShip in('职员', '科长')

6.选取编号不在c20050001-c20050004之间的客户编号，客户名称，客户地址

select customerNo 客户编号, customerName 客户名称, address 客户地址 from customer

where customerNo not between 'C20050001' and 'C20050004'

7.在表orderMaster中挑选出销售金额大于等于5000元的订单

update OrderMaster set orderSum = sum2 from OrderMaster a, (

select orderNo, sum(quantity*price) sum2 from OrderDetail group by orderNo) b where a.orderNo = b.orderNo

select orderSum from OrderMaster where orderSum>5000 order by orderSum

8.在订单主表中选择订单金额最高的前百分之10的订单数据

select top 10 percent * from OrderMaster order by orderSum desc