title: Select all rows that have no children
body: <p>I'm really having a brain-fail on this one.</p>
  
  <p>I have the following table:</p>
  
  <pre>
  id    parentID     name
  1     0            Frank
  2     1            Sally
  3     1            John
  4     3            Beth
  </pre>
  
  <p>I'd like a statement that selects only those items that have no children, so in the previous example:</p>
  
  <pre><code>Sally
  Beth
  </code></pre>
  
  <p>Would be the result. Can't seem to figure out a query to do this without creating a recursive function, which I don't want do to if I can avoid.</p>