根據(jù) 省市區(qū)層級關(guān)系將數(shù)據(jù)歸納整理，題目如下

答：可以按照省市區(qū)三級查詢臨時表，然后根據(jù)parentid將3張臨時表關(guān)聯(lián)。

方法一：

select * into #a1 from DuoJi where ParentId=0
select * into #a2 from DuoJi where ParentId in (select id from #a1)
select * into #a3 from DuoJi where ParentId in (select id from #a2)

select a1.Name as '一級地名',a2.Name as '二級地名',a3.Name as '三級地名' from #a3 a3 inner join #a2 a2 on a3.ParentId=a2.Id inner join #a1 a1 on a2.ParentId=a1.Id

方法二：

select faddr.name '一級地名',saddr.name '二級地名',taddr.name '三級地名' from address a 
join (SELECT id,name,parent_id from address) faddr on a.id=faddr.id
                        join (SELECT id,name,parent_id from address) saddr on faddr.id=saddr.parent_id
                        join (SELECT id,name,parent_id from address) taddr on saddr.id=taddr.parent_id