资源描述：
《2011司考试卷一及答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、一、/*水排口一污染物实时数据查询*/:SELECTMIN(strength),AVG(strength),MAX(strength)FROM[AutoMonitorDB].[MonitorOperationData].[WaterFacRTData]where[MonitorTime]between'2012-08-2020:01:00.000'and'2012-08-2020:10:00.000'and[PollutantCode]='001'and[OutputCode]='1'/*水排口一污
2、染物十分钟数据查询*/:SELECTMinstrength,Avgstrength,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]='2012-08-2020:10:00.000'and[PollutantCode]='001'and[OutputCode]='1'二、/*水排口一污染物小时数据查询*/：SELECTMinstrength,Avgstrength
3、,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[WaterFacHourData]where[MonitorTime]='2012-08-2021:00:00.000'and[PollutantCode]='001'and[OutputCode]='1'/*水排口一污染物十分钟数据查询*/：SELECTMIN(Minstrength),AVG(Avgstrength),MAX(Maxstrength)FROM[AutoMonitorDB
4、].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]between'2012-08-2020:10:00.000'and'2012-08-2021:00:00.000'and[PollutantCode]='001'and[OutputCode]='1'三、/*水排口实时数据*（10个水排口实时数据的最小、平均、最大）/SELECTmin(FlowVelocity),avg(FlowVelocity),max(FlowVel
5、ocity)FROM[AutoMonitorDB].[MonitorOperationData].[WaterOutputRTData]where[MonitorTime]between'2012-08-2020:01:00.000'and'2012-08-2020:10:00.000'and[OutputCode]='1'/*水排口十分钟数据*/SELECTMinFlow,AvgFlow,MaxFlow,CouFlowFROM[AutoMonitorDB].[MonitorOperationDat
6、a].[WaterOutputTenMinsData]where[MonitorTime]between'2012-08-2020:10:00.000'and'2012-08-2020:10:00.000'and[OutputCode]='1'四、/*水排口十分钟数据（6个十分钟数据的最小、平均、最大）*/SELECTmin(MinFlow),avg(AvgFlow),max(MaxFlow)FROM[AutoMonitorDB].[MonitorOperationData].[WaterOutpu
7、tTenMinsData]where[MonitorTime]between'2012-08-2020:10:00.000'and'2012-08-2021:00:00.000'and[OutputCode]='1'/*水排口小时数据*/SELECT[MinFlow],[AvgFlow],[MaxFlow]FROM[AutoMonitorDB].[MonitorOperationData].[WaterOutputHourData]where[MonitorTime]='2012-08-2021:0
8、0:00.000'and[OutputCode]='1'/*水污染物十分钟数据（6个十分钟数据）*/SELECTmin(MinStrength),avg(AvgStrength),max(MaxStrength),sum(CouFlow)FROM[AutoMonitorDB].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]between'2012-08-2120:10:00.000'and'
