WITH T AS (
SELECT ID,PID FROM TableName WHERE ID=1
UNION ALL
SELECT A.* FROM (SELECT ID,PID FROM TableName) A INNER JOIN T ON A.PID=T.ID
)
SELECT * FROM T
在 MSSQL 中实现简单数据类型的数据递归
最新推荐文章于 2022-11-12 11:23:09 发布
WITH T AS (
SELECT ID,PID FROM TableName WHERE ID=1
UNION ALL
SELECT A.* FROM (SELECT ID,PID FROM TableName) A INNER JOIN T ON A.PID=T.ID
)
SELECT * FROM T