title: Recursive selection of categories
body: <p>In my database I have the following table:</p>
  
  <pre><code>Category: {[Name: VarChar, TopCategory: VarChar]}
  </code></pre>
  
  <p>The Table has the following contents:</p>
  
  <p><img src="https://i.stack.imgur.com/IWyOp.png" alt="Contents of the Table"></p>
  
  <p>Now I need to get all names from all subcategories of the category <code>Computer Science</code> using the <code>with-clause</code> in a recursive statement.
  This has to be done using SQL, no PHP or other programming language.</p>
  
  <p>All subcategories means not only the direct decendants but also in this case <code>C++</code> and <code>Java</code>
  How do I do this?</p>
  
  <p>What I do have so far:</p>
  
  <pre><code>SELECT name FROM category WHERE (topcategory = 'Computer Science')
  </code></pre>