Skip to content

Latest commit

 

History

History
92 lines (81 loc) · 2.21 KB

File metadata and controls

92 lines (81 loc) · 2.21 KB

Advance SQL Analytical Functions

MATCH_RECOGNIZE

    {% for page in site.pages %} {% if page.title contains "MATCH_RECOGNIZE" %}
  • {{ page.title | escape }}
  • {% endif %} {% endfor %}

ASOF JOIN

Skyline Query

Dynamic PIVOT

Conditional True Event (conditional_true_event)

    {% for page in site.pages %} {% if (page.title contains "Sessionization" or page.title contains "conditional_true_event" or page.title contains "Conditional True Event") %}
  • {{ page.title | escape }}
  • {% endif %} {% endfor %}

Conditional Change Event (conditional_change_event)

    {% for page in site.pages %} {% if (page.title contains "Conditional Change Event") or page.title contains "conditional_change_event") %}
  • {{ page.title | escape }}
  • {% endif %} {% endfor %}

Ratio to Report (ratio_to_report)

    {% for page in site.pages %} {% if page.title contains "RATIO_TO_REPORT" %}
  • {{ page.title | escape }}
  • {% endif %} {% endfor %}

JSON