只要换一下思路, 就可以实现了:
[php]
--
SQL> select * from t;
C1 C2
---- --------------------
AAADFGFDDSAFDS
AAADSGFSGFGGFDSG
BBBSDGSDFGFDG
CCCASFDSAFDASFDS
CCCDSGDFSGFSDGFDG
DDDASFADFDSFSDF
已选择6行。
--子查询, 8I以后可用
SQL> select t1.c1, t2.rn, t1.c2
2 from t t1, (select c1, rownum rn
3
from (select distinct c1 from t order by c1)
4
) t2
5 where t1.c1=t2.c1;
C1 RN C2
---- ---------- --------------------
AAA 1 DSGFSGFGGFDSG
AAA 1 DFGFDDSAFDS
BBB 2 SDGSDFGFDG
CCC 3 DSGDFSGFSDGFDG
CCC 3 ASFDSAFDASFDS
DDD 4 ASFADFDSFSDF
已选择6行。
--分析函数, 817以后可用,
SQL>select c1 col1, dense_rank() over(order by c1) col2, c2 col3 from t;
COL1 COL2 COL3
---- ---------- --------------------
AAA 1 DFGFDDSAFDS
AAA 1 DSGFSGFGGFDSG
BBB 2 SDGSDFGFDG
CCC 3 ASFDSAFDASFDS
CCC 3 DSGDFSGFSDGFDG
DDD 4 ASFADFDSFSDF
已选择6行。
--[/php]
|