原始数据
coml1 coml2 coml3
-----------------------------------
101 a 1
102 b 1
103 c 1
104 d 2
105 e 2查询完
ROWNUM coml1 coml2 coml3
------------------------------------
1 101 a 1
2 102 b 1
3 103 c 1
1 104 d 2
2 105 e 2按照coml3分组编号..
coml1 coml2 coml3
-----------------------------------
101 a 1
102 b 1
103 c 1
104 d 2
105 e 2查询完
ROWNUM coml1 coml2 coml3
------------------------------------
1 101 a 1
2 102 b 1
3 103 c 1
1 104 d 2
2 105 e 2按照coml3分组编号..
(
coml1 NUMBER(4),
coml2 VARCHAR2(20),
coml3 NUMBER(4)
);
INSERT INTO T74 VALUES(101, 'a', 1);
INSERT INTO T74 VALUES(102, 'b', 1);
INSERT INTO T74 VALUES(103, 'c', 1);
INSERT INTO T74 VALUES(104, 'd', 2);
INSERT INTO T74 VALUES(105, 'e', 2);
实测结果: