SQL SERVER with递归示例一则

 WITH SUBQUERY AS (
     SELECT
         ORGID
     FROM
         OM_ORGANIZATION
     WHERE
         PARENTORGID = 'ROOT'

     UNION ALL

         SELECT
             B.ORGID
         FROM
             SUBQUERY A,
             OM_ORGANIZATION B
         WHERE
             B.PARENTORGID = A.ORGID
 ) SELECT DISTINCT
     *
 FROM
     SUBQUERY