Get to know the power of SQL recursive queries
Tutorials Shared by the Internet Community
Total Hits - 40516
Total Votes - 13 votes
Vote Up - 6 votes
Vote Down - 7 votes
Domain - www.vertabelo.com
Category - Basic SQL/Advanced SQL
Submitted By - Patrycja Dybka
Submitted on - 2015-03-24 09:21:02
Most commonly, the SQL queries we run on a database are quite simple. Well, that depends on your role, of course. Analysts in data warehouses retrieve completely different sorts of information using (very often) much more complicated queries than software engineers creating CRUD applications.
However, sometimes it's simpler or more elegant to run a query that is a little bit more sophisticated without needing further data processing in the code. One way to accomplish this is with a SQL feature called recursive queries. More detail...