数据库SQL查询语句实验报告(3)

(8) 查找定单金额高于8000的所有客户编号。 命令：

select CustomerNo

from OrderDetail as a,OrderMaster as b where a.orderNo =b.orderNo group by CustomerNo

having sum(quantity *price )>8000 结果：

(9) 选取编号界于“C20050001”和“C20050004”的客户编号、客户名称、客户地址。 命令：

SELECT CustomerNo ,CustomerName ,address FROM Customer

WHERE CustomerNo BETWEEN 'C20050001' AND 'C20050004' 结果：

(11) 找出同一天进入公司服务的员工。 命令：

select hireDate ,employeeName from Employee as a where exists

(select * from Employee as b

where a.hireDate =b.hireDate and a.employeeNo !=b.employeeNo ) group by hireDate ,employeeName 结果：

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库数据库SQL查询语句实验报告(3)在线全文阅读。