资源描述:
《2014-2019年中国橡胶防老剂市场全景调查与行业运营态势报告》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
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'/*水排口一污染物十分钟数据查询*/:SELECTMinstrengt
2、h,Avgstrength,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[WaterFacTenMinsData]where[MonitorTime]='2012-08-2020:10:00.000'and[PollutantCode]='001'and[OutputCode]='1'二、/*水排口一污染物小时数据查询*/:SELECTMinstrength,Avgstrength,MaxstrengthFROM[AutoMonitorDB].[MonitorOperationData].[
3、WaterFacHourData]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
4、:10:00.000'and'2012-08-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
5、.000'and'2012-08-2020:10:00.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个十分钟
6、数据的最小、平均、最大)*/SELECTmin(MinFlow),avg(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[AutoMonit
7、orDB].[MonitorOperationData].[WaterOutputHourData]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[Monitor
8、Time]between'2012-08-2120:10:00.000'and'