用(select…start with…connect by…prior) 具体给你个参考地址：http://www.cnblogs.com/linjiqin/archive/2013/06/24/3152674.html
