id 连续,name 一样的, value 加和

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/