Get to know the power of SQL recursive queries

Tutorials Shared by the Internet Community

Advertisements


Get to know the power of SQL recursive queries

Get to know the power of SQL recursive queries on a real-life example.

Statistics

  • 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

Description

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...


Broken  |   Save  |   Liked  |   Down

Advertisements