select * from sys_department
start with departmentid =  '0303e461-2454-4d5a-bfea-2cd5a4c064c6' 
  connect by prior departmentid = parentid 

 

posted on 2018-03-05 11:22  vinsonLu  阅读(3589)  评论(0编辑  收藏  举报