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

Spam comments are purged and not published. Review is done manually and therefore it usually takes between some hours and one day until a comment will be published.