资源描述：
《毕业论文 毕业设计选题列表1》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
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'/*水排口一污染物十分钟数据查询*/:SELECTMinstrength,Avgst
2、rength,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]='2012-08-2020:10:00.000'and[PollutantCode]='001'and[OutputCode]='1'二、/*水排口一污染物小时数据查询*/：SELECTMinstrength,Avgstrength,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[WaterFacHourDa
3、ta]where[MonitorTime]='2012-08-2021:00:00.000'and[PollutantCode]='001'and[OutputCode]='1'/*水排口一污染物十分钟数据查询*/：SELECTMIN(Minstrength),AVG(Avgstrength),MAX(Maxstrength)FROM[AutoMonitorDB].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]between'2012-08-2020:10:00.000'and'2012-0
4、8-2021:00:00.000'and[PollutantCode]='001'and[OutputCode]='1'三、/*水排口实时数据*（10个水排口实时数据的最小、平均、最大）/SELECTmin(FlowVelocity),avg(FlowVelocity),max(FlowVelocity)FROM[AutoMonitorDB].[MonitorOperationData].[WaterOutputRTData]where[MonitorTime]between'2012-08-2020:01:00.000'and'2012-08-2020:10:00.
5、000'and[OutputCode]='1'/*水排口十分钟数据*/SELECTMinFlow,AvgFlow,MaxFlow,CouFlowFROM[AutoMonitorDB].[MonitorOperationData].[WaterOutputTenMinsData]where[MonitorTime]between'2012-08-2020:10:00.000'and'2012-08-2020:10:00.000'and[OutputCode]='1'四、/*水排口十分钟数据（6个十分钟数据的最小、平均、最大）*/SELECTmin(MinFlow),av
6、g(AvgFlow),max(MaxFlow)FROM[AutoMonitorDB].[MonitorOperationData].[WaterOutputTenMinsData]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].[WaterOutputH
7、ourData]where[MonitorTime]='2012-08-2021:00: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'
