ITPub博客

create table t01(col1 number);inser into t01 vaues(1):inser into t01 vaues(2):inser into t01 vaues(3):inser into t01 vaues(6):inser into t01 vaues(7):inser into t01 vaues(9):inser into t01 vaues(10):需查询结果：min max count------------------------1 3 36 7 29 10 2即统计连号数[@more@]select min(col1), max(col1),count(*)from (select col1,col1 - row_number() over (order by col1) rn from t01)group by rn;