WITH stepCTE AS (
select
G . ID,
G .parentid
FROM
ad_company G
WHERE
G . ID = 10000001
UNION ALL
SELECT
A . ID,
A .parentid
FROM
ad_company A
INNER JOIN StepCTE CTE ON CTE. ID = A .parentid
) SELECT
ID
FROM
stepCTE
**oracle递归查询**
SELECT
ID
FROM
ad_company START WITH ID = 10000001 CONNECT BY parentid = PRIOR ID
sqlserver递归查询
最新推荐文章于 2023-07-25 08:46:32 发布