求助DBA,复杂的存储过程
表结构
create table db1(
devno varchar2(10), --设备号码
value varchar2(10), --值
time date, --数据保存时间
)
需求 :统计今年每个月该表值为1-5,5-10,10-15的记录数,转存到另外一张表。转存表记录设备号,记录数,值,时间。
[解决办法]
insert into tbname
select '1-5',count(*)
from tb
where value between 1 and 5;
insert into tbname
select '1-5',count(*)
from tb
where value between 5 and 10;
insert into tbname
select '1-5',count(*)
from tb
where value between 10 and 15;