树形结构语法

with subqry(CODE,NAME,PCODE) as (
  select CODE,NAME,PCODE from Category where CODE = ‘fa3e09f7-1db7-4fa2-92a4-106e35e136ea‘
  union all
  select Category.CODE,Category.NAME,Category.PCODE from Category,subqry
  where Category.PCODE = subqry.CODE
  )
  select * from subqry;

本文出自 “战争之影” 博客，请务必保留此出处http://rmlifejun.blog.51cto.com/7683304/1619544

树形结构语法

原文：http://rmlifejun.blog.51cto.com/7683304/1619544