Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Some SQL DBMs allow to create recursive queries. That's a feature of  DB2 (free download ), SQL Server and Oracle. Unfortunately mySQL misses this feature. But every recursive algorithm can be written in a non recursive way - so it's not clear whether this is a need or just a nice DBMS feature. Anyhow - it's an interesting topic.

 
References:
 
3) Trees and other hierachies (no recursion)
 
 
Add comment

*** Note ***

Comments are welcome. But in order to reject spam posts please consider following rules:
  1. Comments with string http are rejected with message You have no rights to use this tag
  2. All comments are reviewed by hand and thus it usually takes one day until a comment will be published.