Write a SQL2 query to fetch nodes without any child nodes

[vitis90]

Hi all,

I'm trying to write a SQL2 query to fetch nodes which don't have any child nodes. That is, the query should fetch the list of nodes which doesn't have any child nodes under those nodes.

Is there any way to achieve this?

[VeenaVikraman · Accepted solution]

I am afraid if that is achievable directly using SQL2 query