select * from direction where (select count(1) from direction e where e.direction_parent_cd=direction.direction_cd) = 0