34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM menu t WHERE t.menuId = 3
SELECT * FROM menu t WHERE t.menuId = 3
OR ( t.menuId IN(SELECT m.parentId FROM menu m WHERE m.menuId = 3) )
;with cte as(
SELECT * FROM menu WHERE menuId = 3
union all
SELECT A.* FROM menu a,cte b where a.menuId=b.parentId
)
select * from cte