摘要:
用标准sql的with实现递归查询with subqry(id,name,pid) as ( select id,name,pid from test1 where id = 5 --指定id union all select test1.id,test1.name,test1.pid from t 阅读全文
posted @ 2018-09-08 20:17 且行且思 阅读(1231) 评论(0) 推荐(0)
|
|||
|
摘要:
用标准sql的with实现递归查询with subqry(id,name,pid) as ( select id,name,pid from test1 where id = 5 --指定id union all select test1.id,test1.name,test1.pid from t 阅读全文
posted @ 2018-09-08 20:17 且行且思 阅读(1231) 评论(0) 推荐(0) |
|||