- WITH temp
- AS
- (
- SELECT *,1 Level FROM [AreaTable] WHERE Parentid = #{child.Id}
- UNION ALL
- SELECT m.*,Level+1 FROM [AreaTable] AS m
- INNER JOIN temp AS child ON m.Parentid = child.Id
- )
- SELECT * FROM temp
-
- 本文自己百度到的粘贴而成,没有任何价值,只供自己做个记录,如有侵权,敬请谅解
查出树状结构的子元素以及所有子子元素,以便删除
最新推荐文章于 2023-08-22 18:14:04 发布