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 manually and thus it usually takes one day until a comment will be published.