db2 with语法和递归
1. 创建测试表
CREATE TABLE someplace
(
ID INTEGER NOT NULL PRIMARY KEY,
ParentID INT,
NAME VARCHAR(100)
);
INSERT INTO someplace VALUES(001,null,'陕西省');
INSERT INTO someplace VALUES(002,001,'商洛市');
INSERT INTO someplace VALUES(003,001,'西安市');
INSERT INTO someplace VALUES(004,001,'咸阳市');