The wonders of CTE's
Hein Kruger is a Jnr.Developer at Goodx Software, a South African based software company that operates in the Medical Sector.
Most of his work day he sits in front of a query window , Wrestling to ensure that Data integrity is maintained.
He is Passionate About Everything Computer related software and hardware included, and firmly believes that computers is a recourse we should use to improve our future.
This is a Quick introduction to the use of CTE's . I will touch on the benefits but mostly its just some practical uses of the CTE structure as well as the use of recursive CTE's.
- What is a Common Table Expression
- Basic Syntax
- Basic Example
- Comparing a CTE with a Nested Query
- Selecting from a CTE
- Using an Update in a CTE
- Using a Delete in a CTE
- Using a Insert in a CTE
- Recursive CTE’s Basic Syntax
- Quick practical example of a recursive CTE
- 2019 March 22 13:30
- 20 min
- Riverside Suite
- Postgres Conference
- Use Cases