POWER EDUCATION | Advanced sql (fortsat)

POWER EDUCATION | Advanced sql (fortsat)

1. Advanced SQL

1. • Common Table Expressions
   • Group By / Having

• Aggregate Functions
• LISTAGG and SPLIT
• Multi-Dimensional Grouping (Sub-Totals / Totals)

1. • OLAP Specifications

• Numbering / Running Totals

1. • SQL and IFS
   • Recursion

• Recursive CTE
• Hierarchical Query Clause

1. • Regular Expressions