create table etltable(
name varchar(20) ,
seq integer,
money integer);
create table etltarget (
name varchar(20),
min_s integer,
max_s integer,
sum_money integer);
insert into etltable values
('A',1,100),
('A',2,200),
('A',3,300),
('A',8,400),
('A',9,500),
('B',1,100),
('B',2,500),
('B',5,600);
目标表结果应该是这样
A 1 3 600
A 8 9 900
B 1 2 600
B 5 5 600
select name,min(seq),max(seq),sum(money)
from (
select a.*, seq - row_num as cha from (
select name,seq,money,row_number() over(partition by name order by seq ) as row_num
from etltable ) a) b group by name, cha
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7899089/viewspace-732689/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7899089/viewspace-732689/