<ol>
<li>Hierarchical sql<br />This is all about the connect by-statement</li>
</ol>
- Hierarchical sql
This is all about the connect by-statement - Partitioned joins
- Subquery factoring
This is all about the with-statement - Recursive sql
- Aggregate sql
This is all about extensions to the group by-statement: grouping sets, rollup and cube, but also the pivot-statement - Analytical or windowing sql
- Sql modelling
