DB2生成自增ID

DB2生成自增ID

--1) 创建测试表
CREATE TABLE palan.db2_increment(
A VARCHAR(255)
);

--2）插入测试数据
INSERT INTO palan.db2_increment VALUES('A');
INSERT INTO palan.db2_increment VALUES('B');
INSERT INTO palan.db2_increment VALUES('C');
INSERT INTO palan.db2_increment VALUES('D');
INSERT INTO palan.db2_increment VALUES('E');
COMMIT;

--3) DB2自增ID
SELECT ROW_NUMBER() OVER(ORDER BY T.A) AS ROW_NUM,T.A FROM palan.db2_increment T;

ROW_NUM	A
1	A
2	B
3	C
4	D
5	E