- 论坛徽章:
- 0
|
有一表
his_data
结构如下
occur_time datetime,
value number(10,2)
occur_time存放的是每分钟采样时间,value是采样值内容如下:
occur_time value
=================================================
2005-11-26 10:00:00 29.33
2005-11-26 10:01:00 27.83
2005-11-26 10:02:00 31.20
2005-11-26 10:03:00 32.02
2005-11-26 10:04:00 28.20
2005-11-26 10:05:00 34.02
2005-11-26 10:06:00 32.47
2005-11-26 10:07:00 35.82
2005-11-26 10:08:00 31.70
2005-11-26 10:09:00 35.22
2005-11-26 10:10:00 38.39
2005-11-26 10:11:00 29.93
(以下省略)
请大家帮忙写一SQL,把采样间隔保留5分钟的点,其他的删掉,结果如下
occur_time value
=================================================
2005-11-26 10:00:00 29.33
2005-11-26 10:05:00 34.02
2005-11-26 10:10:00 38.39
2005-11-26 10:15:00 42.72
(以下省略)
多谢! |
|