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 /
解决方案 »
- 求助xmldb中文问题
- 关于oracle 存储过程的问题 跪求各位大神解决
- 关于SQL预计编写时的小小问题
- 从sybase 数据库表中抓取数据放到Oracle 数据库表中 问题……
- Clob字段中字符替换求助(注意,大于32K)
- oracle 的dump_cvs过程导出数据到cvs报错,谢谢!
- 急急急,急死人了,错误 7399 OLE DB 提供程序 'MSDAORA' 报错。
- 关于SQL分组查询的问题,请高手指点!
- 在线等!请哪位提供oracle9.2.0 for linux 的下载地址
- 我在用pb8.0的数据管道把数据从oracle7.3导入到oracle9i时:
- MYSQL怎么查询两个时间之间的日期列表
- oracle表关联查询
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在这报不允许序号呢?