ref:
SQL> select b.fphm,min(b.kshm),max(b.kshm)
2 from (
3 select a.*,to_number(a.kshm-rownum) cc
4 from (
5 select * from t order by fphm,kshm
6 ) a
7 ) b
8 group by b.fphm,b.cc
9 /
SQL> select b.fphm,min(b.kshm),max(b.kshm)
2 from (
3 select a.*,to_number(a.kshm-rownum) cc
4 from (
5 select * from t order by fphm,kshm
6 ) a
7 ) b
8 group by b.fphm,b.cc
9 /
select
gp_year,min(years)||'-'||max(years)
from
(
select
a.years
,decode(a.year,b.years+1,seq_test.nextval,seq_test.currval) gp_year
from (select *,row_num() _rows from t order by years) a
left join(select ,row_num() _rows from t order by years)b
on a.rows = (b.rows+1)
) years_group
group by gp_year
gp_year,min(years)||'-'||max(years)
from
(
select
a.years
,decode(a.year,b.years+1,seq_test.nextval,seq_test.currval) gp_year
from (select *,row_num() _rows from t order by years) a
left join(select ,row_num() _rows from t order by years)b
on a.rows = (b.rows+1)
) years_group
group by gp_year
select gp_year, min(years) || '-' || max(years)
from (select a.years,
decode(a.years,
b.years+ 1,
seq_test.nextval,
seq_test.currval) gp_year
from (select years, rownum rows1
from t order by years) a
left join (select rownum rows1
from t
order by years) b
on a.rows1 = (b.rows1 + 1)) year_group
group by gp_year
为什么seq_test.nextval,seq_test.currval在这报不允许序号呢?