sql语句获取叶子节点

表结构 为
id parentid name
1    0
2    0
3    1
4    3
5    2
输入0现在想得到
4 5
也就是获取叶子节点，改怎么实现？ 谢谢

---

http://blog.csdn.net/wufeng4552/archive/2009/09/30/4619995.aspx

---

我要的是叶子节点，就是最底层的节点

---

0 得到4,5 ?

---

引用

http://blog.csdn.net/wufeng4552/archive/2009/09/30/4619995.aspx

这个好

---

BOM　精华

---

对 0 得到 4 5

---

SQL code:
-->Title:Generating test data
-->Author:wufeng4552
-->Date :2009-09-30 14:27:56

if not object_id('tb') is null
drop table tb
Go
Create table tb([id] int,[parentid] int,[name] varchar(10))
Insert tb
select 1,0,null union all
select 2,0,null union all
select 3,1,null union all
select 4,3,null union all
select 5,2,null
Go
-->Title:查找指定節點下的子結點
if object_id('Uf_GetChildID')is not null drop function Uf_GetChildID
go
create function Uf_GetChildID(@ParentID int)
returns @t table(ID int)
as
begin
insert @t select ID from tb where ParentID=@ParentID
while @@rowcount<>0
begin
insert @t select a.ID from tb a inner join @t b
on a.ParentID=b.id and
not exists(select 1 from @t where id=a.id)