select * from tb a where not exists ( select * from tb where fid=a.id )
create table A ( id int, P_id int )insert A select 1,0 insert A select 2,1 insert A select 3,1 insert A select 4,3 insert A select 5,2 select * from A where id not in (select P_id from A)
from tb a
where
not exists
(
select * from tb where fid=a.id
)
(
id int,
P_id int
)insert A select 1,0
insert A select 2,1
insert A select 3,1
insert A select 4,3
insert A select 5,2
select * from A where id not in (select P_id from A)