SELECT * FROM pubcoursesort
CONNECT by coursesortid = prior fatherid
START WITH coursesortid =10210
-------------------------
请问这里的 CONNECT by coursesortid = prior fatherid 什么意思呀
CONNECT by coursesortid = prior fatherid
START WITH coursesortid =10210
-------------------------
请问这里的 CONNECT by coursesortid = prior fatherid 什么意思呀
...PRIOR expr = expr 或 ...expr = PRIOR expr
这个其实是属于层次查询!