发布时间 : 星期日 文章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