绝代双骄 慕容九:一个sql语句看不懂

来源:百度文库 编辑:高考问答 时间:2024/05/06 02:11:17
WITH selectTree(id,parent_id,group_id,group_name,group_level,tree_deep) as (select root.id,root.parent_id,root.group_id,root.group_name,root.group_level,root.tree_deep from t_el_group as root where root.id=101 UNION ALL select child.id,child.parent_id,child.group_id,child.group_name,child.group_level,child.tree_deep from selectTree as parent,t_el_group as child where parent.id=child.parent_id ) select id,parent_id,group_id,group_name,group_level,tree_deep from selectTree order by tree_deep,group_level asc
这个句子中的with什么用啊

我来看看