7.4700
7.4700
7.4700
------
7.2000
7.2000
------
7.4700
7.4700
------
6.9300
6.9300
6.9300
------
7.2000
想得到的结果(相同并且连续的是一个分组):7.4700
7.2000
7.4700
6.9300
7.2000
7.4700
7.4700
------
7.2000
7.2000
------
7.4700
7.4700
------
6.9300
6.9300
6.9300
------
7.2000
想得到的结果(相同并且连续的是一个分组):7.4700
7.2000
7.4700
6.9300
7.2000
SQL> SELECT * FROM TABLE_NAME; STR
----------
7.47
7.47
7.47
7.2
7.2
7.47
7.47
6.93
6.93
6.93
7.211 rows selectedSQL> SELECT STR
2 FROM (
3 SELECT TT.*,
4 ROWNUM-ROW_NUMBER() OVER(PARTITION BY STR ORDER BY ROWNUM) RN,
5 ROW_NUMBER() OVER(PARTITION BY STR ORDER BY ROWNUM),
6 ROWNUM
7 FROM TABLE_NAME TT
8 )ZZ
9 GROUP BY STR,RN
10 ORDER BY RN; STR
----------
7.47
7.47
7.2
6.93
7.2