select * from tablename start with 条件1 connect by prior 条件2 where 条件3 转载于:https://www.cnblogs.com/wangc04/p/6378481.html