analytical-sql-examples

Run these "analytics"-prefixed scripts standalone, or follow them as part of the complete Analytics class at https://tinyurl.com/devgym-classes

Name		Name	Last commit message	Last commit date
parent directory ..
README.md		README.md
analytics-18c-approx_count-function.sql		analytics-18c-approx_count-function.sql
analytics-18c-character-encoding-validation.sql		analytics-18c-character-encoding-validation.sql
analytics-Deleting-Duplicates.sql		analytics-Deleting-Duplicates.sql
analytics-Display-columns-as-rows-for-any-SQL-query.sql		analytics-Display-columns-as-rows-for-any-SQL-query.sql
analytics-Dynamically-sized-windows.sql		analytics-Dynamically-sized-windows.sql
analytics-First-look-at-Window-functions.sql		analytics-First-look-at-Window-functions.sql
analytics-Grouping-ranges-of-data.sql		analytics-Grouping-ranges-of-data.sql
analytics-How-null-values-are-treated.sql		analytics-How-null-values-are-treated.sql
analytics-How-to-apply-predicates.sql		analytics-How-to-apply-predicates.sql
analytics-Hypothetical-ranking-and-RATIO_TO_REPORT.sql		analytics-Hypothetical-ranking-and-RATIO_TO_REPORT.sql
analytics-In-list-processing.sql		analytics-In-list-processing.sql
analytics-LAG-and-LEAD-extensions.sql		analytics-LAG-and-LEAD-extensions.sql
analytics-LAG-and-LEAD-functions.sql		analytics-LAG-and-LEAD-functions.sql
analytics-LISTAGG-with-the-OVER-clause.sql		analytics-LISTAGG-with-the-OVER-clause.sql
analytics-More-complex-ranking-functions.sql		analytics-More-complex-ranking-functions.sql
analytics-More-ranking-options.sql		analytics-More-ranking-options.sql
analytics-More-window-clause-examples.sql		analytics-More-window-clause-examples.sql
analytics-Optimizer-Improvements-for-ANSI-fetch-first-offset-queries.sql		analytics-Optimizer-Improvements-for-ANSI-fetch-first-offset-queries.sql
analytics-PIVOT-and-UNPIVOT-functions.sql		analytics-PIVOT-and-UNPIVOT-functions.sql
analytics-Partition-clause-with-aggregation.sql		analytics-Partition-clause-with-aggregation.sql
analytics-Partitioned-Outer-Join.sql		analytics-Partitioned-Outer-Join.sql
analytics-Ranking-part-3.sql		analytics-Ranking-part-3.sql
analytics-Ranking-rows-across-an-entire-table.sql		analytics-Ranking-rows-across-an-entire-table.sql
analytics-The-KEEP-clause.sql		analytics-The-KEEP-clause.sql
analytics-The-LISTAGG-function.sql		analytics-The-LISTAGG-function.sql
analytics-The-RANGE-options-for-windows.sql		analytics-The-RANGE-options-for-windows.sql
analytics-Using-the-PARTITION-clause.sql		analytics-Using-the-PARTITION-clause.sql
analytics-Window-boundaries.sql		analytics-Window-boundaries.sql
analytics-Windows-and-null-values.sql		analytics-Windows-and-null-values.sql
analytics-Windows-and-the-NTH_VALUE-function.sql		analytics-Windows-and-the-NTH_VALUE-function.sql
analytics-the-Tabitosan-method.sql		analytics-the-Tabitosan-method.sql

FilesExpand file tree

analytical-sql-examples

Directory actions

More options

Directory actions

More options

Latest commit

History

analytical-sql-examples

Folders and files

parent directory

README.md