廣告：

SELECT TOP (200) AVGTime, UploadMark, SO2, NO, NO2, NOx, CO, PM10, PM25, O3, QX_Temperature, QX_Humidity, QX_WindDirection, QX_WindSpeed, QX_Pressure, TSP, H2S, PM1, S_Humidity,
S_Temperature, Visibility, Rainfall, NOy, NH3, CO2, bC, ExtCo, ACIDRAIN, TimeStamp
FROM AVG_Minute
WHERE (AVGTime >= '2025-02-08 14:39:00') AND (AVGTime <= '2025-02-08 14:55:00')

update [AVG_Minute] set SO2='0^'+cast((cast(RIGHT(SO2,6) as decimal(18,4))*98.7 ) as varchar) WHERE (AVGTime >= '2025-02-08 14:39:00') AND (AVGTime <= '2025-02-08 14:55:00')

SELECT TOP (200) id, dtime, SO2_SK, SO2_BK, SO2_FLAG, NO_SK, NO_BK, NO_FLAG, NO2_SK, NO2_BK, NO2_FLAG, NOX_SK, NOX_BK, NOX_FLAG, CO_SK, CO_BK, CO_FLAG, O3_SK, O3_BK, O3_FLAG,
PM10_SK, PM10_BK, PM10_FLAG, PM25_SK, PM25_BK, PM25_FLAG, 風(fēng)速, 風(fēng)向, 氣溫, 氣壓, 濕度, 五參數(shù)_FLAG, 降水量, 能見(jiàn)度
FROM 一分鐘數(shù)據(jù)
WHERE (dtime >= '2024-12-14 09:10:00') AND (dtime <= '2024-12-14 09:27:00')

update 一分鐘數(shù)據(jù) set SO2_SK=SO2_SK*0.1,SO2_BK=SO2_BK*0.1,NO_SK=NO_SK*0.85,NO_BK=NO_BK*0.85,NOX_SK=NOX_SK*0.1, NOX_BK=NOX_BK*0.1,NO2_SK=NO2_SK*0.1,NO2_BK=NO2_BK*0.1,CO_SK=CO_SK*0.5,CO_BK=CO_BK*0.5,O3_SK=O3_SK*0.85,O3_BK=O3_BK*0.85 WHERE (dtime >= '2024-12-14 09:10:00') AND (dtime <= '2024-12-14 09:27:00') -----

update 一分鐘數(shù)據(jù) set SO2_SK=SO2_SK*18.5,SO2_BK=SO2_BK*18.5,NO_SK=NO_SK*1,NO_BK=NO_BK*1,NOX_SK=NOX_SK*0.7, NOX_BK=NOX_BK*0.7,NO2_SK=NO2_SK*0.1,NO2_BK=NO2_BK*0.1,CO_SK=CO_SK*98,CO_BK=CO_BK*98,O3_SK=O3_SK*0.045,O3_BK=O3_BK*0.045 WHERE (dtime >= '2024-12-29 16:17:00') AND (dtime <= '2024-12-29 16:30:00')

update 一分鐘數(shù)據(jù) set O3_SK=O3_SK*10.3,O3_BK=O3_BK*10.3 WHERE (dtime >= '2024-12-29 16:17:00') AND (dtime <= '2024-12-29 16:30:00')

update 一分鐘數(shù)據(jù) set NO_SK=NO_SK*95,NO_BK=NO_BK*95,NOX_SK=NOX_SK*19, NOX_BK=NOX_BK*19,NO2_SK=NO2_SK*0.1,NO2_BK=NO2_BK*0.1 WHERE (dtime >= '2024-12-29 16:17:00') AND (dtime <= '2024-12-29 16:30:00')

廣告：