Server단에서의 계산 예제

SELECT

(SELECT SUM(m01) FROM T_DATA WHERE sensor_id = 64 AND [date] > '2007-04-03 11:00:00' AND [date] < '2007-04-03 11:10:44' AND m01 < 99999.0),

(SELECT SUM(m01) FROM T_DATA WHERE sensor_id = 64 AND [date] >= '2007-04-03 00:00:00' AND [date] < '2007-04-03 11:10:44' AND m01 < 99999.0),

(SELECT SUM(m01) FROM T_DATA WHERE sensor_id = 64 AND [date] >= '2007-01-01' AND [date] < '2007-04-03 11:10:44' AND m01 < 99999.0)