正文
sql_树形查询
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
with Subqry(FID,A_TypeName,A_ParentID) as
(select FID,A_TypeName,A_ParentID from tb_Appliances where FID='20160802120302537AF2B014DC67AA43D1AD0923EB2BF0A64E'
union all select b.Fid,b.A_TypeName,b.A_ParentID from tb_Appliances b,Subqry
where Subqry.FID=b.A_ParentID
)
select * from Subqry