用SQL实现递归

单表：

select t.typeId,t.typeName,t.parentId from t_data t
start with t.typeId = 3
connect by prior t.typeId = t.parentid

?

关联表：t_ues_pic_rescategory目录表，t_ues_resource 资源表 关联列categoryId

该语句实现递归查询某个目录（包括子目录）下所有资源

select r.*, tp.categoryname
? from t_ues_resource r,
?????? (select t.categoryid, t.categoryname
????????? from t_ues_pic_rescategory t
???????? start with t.categoryid = 27
??????? connect by prior t.categoryid = t.parentid) tp
?where r.categoryid = tp.categoryid
?order by r.uploadtime desc