简答题-模糊查询.docx

《简答题-模糊查询.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、第十章模糊查询1.上机11.上机22.简答题一聚合函数：sum计算总和、avg平均分、max最大值、min最小值、count计数1.简答题二Use****;ØSelectfromHouseInfoØWhere*HouseTypelike‘%一厅%’ØSelect*fromHouseInfoØWhereLandlordlike‘于_玲’ØSelect*fromHouseInfoØWhereAddresslike‘%解放区%’ANDExchangeType=‘出租ØSelectavg（Area）fromHou

2、seInfoØWhereHouseType=一室一厅’’2.简答题三SelectAvg(Name)fromEmployeeWhereSex=’男’Select*fromEmployeeWhereEducation=’本科学历’SelectAvg(Salary)fromEmployeeWhereAge>25SelectMax(Salary),Min(Salary)fromEmployeeWhereSex=’男’SelectMax(Salary),Min(Salary)fromEmployeeWhereSex

3、=’女’1.简答题四草鱼或者是鲶鱼2.简答题五SelectSum(Price*ProductNumber)fromSalesSelectClientName，ProductNumberfromSalesWhere(selectProductNamefromProduct)=’坦克’SelectSum(Price*ProductNumber)fromSalesWhere(selectProductNamefromProduct)=’轮船’