4 years ago

Category: Data, apple

Postgres provides us a way to write queries that are recursive in nature and fetch the data until the termination condition is met. This can be achieved using Common Table Expressions (CTEs). Using the WITH clause, we can create a temporary table scope of which is bound to that query itself.