POWER EDUCATION | Advanced sql

24 Jan 2023
09.00

POWER EDUCATION | Advanced sql

  1. Advanced SQL
    • Common Table Expressions
    • Group By / Having
  • Aggregate Functions
  • LISTAGG and SPLIT
  • Multi-Dimensional Grouping (Sub-Totals / Totals)
    • OLAP Specifications
  • Numbering / Running Totals
    • SQL and IFS
    • Recursion
  • Recursive CTE
  • Hierarchical Query Clause
    • Regular Expressions