DB2递归查询
<span style="font-size: 14px; line-height: 21px;">在db2可以使用sql语句来进行递归查询,就是使用with语句1.先建一个树形表:
<div style="padding-right: 5px; padding-left: 4px; font-size: 13px; padding-bottom: 4px; width: 912px; padding-top: 4px; background-color: #eeeeee; border: 1px solid #cccccc;">http://www.cnblogs.com/Images/OutliningIndicators/None.gifcreate table tst (
http://www.cnblogs.com/Images/OutliningIndicators/None.gifid integer,
http://www.cnblogs.com/Images/OutliningIndicators/None.gifparentId int,
http://www.cnblogs.com/Images/OutliningIndicators/None.gifname varchar(20))
页:
[1]