Analytic and Window Functions For All Systems (Over 100 Blogs)
I wish I had mastered ordered analytics and window functions early in my career, but I was afraid because they were hard to understand. After some time, I found that they are so easy to understand.
I’ve curated a collection of my favorite and most powerful analytics and window functions in this blog post. These step-by-step guides are designed to be practical and applicable to every database system in your enterprise.
I have a list of the top 15 databases worldwide and a link to the analytic blogs for that database. Enjoy!
Each database will have a link to an analytic blog in this order:
Rank
Dense_Rank
Percent_Rank
Row_Number
Cumulative Sum (CSUM)
Moving Difference
Cume_Dist
Lead
Snowflake
https://coffingdw.com/snowflake-analytics-part-2-rank/
https://coffingdw.com/snowflake-analytics-row_number/
https://coffingdw.com/snowflake-analytics-cumulative-sum/
https://coffingdw.com/snowflake-analytics-the-moving-difference/
https://coffingdw.com/snowflake-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-snowflake-working-session/
Databricks
https://coffingdw.com/databricks-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/databricks-analytics-row_number/
https://coffingdw.com/databricks-analytics-cumulative-sum/
https://coffingdw.com/databricks-analytics-moving-difference/
https://coffingdw.com/databricks-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-databricks-working-session/
Google BigQuery
https://coffingdw.com/bigquery-analytics-rank-dense_rank-and-percent-rank/
https://coffingdw.com/google-bigquery-analytics-row_number/
https://coffingdw.com/google-bigquery-analytics-cumulative-sum/
https://coffingdw.com/google-bigquery-analytics-moving-difference/
https://coffingdw.com/google-bigquery-analytics-cume_dist/
Amazon Redshift
https://coffingdw.com/amazon-redshift-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/amazon-redshift-analytics-row_number/
https://coffingdw.com/amazon-redshift-analytics-cumulative-sum/
https://coffingdw.com/amazon-redshift-analytics-moving-difference/
https://coffingdw.com/amazon-redshift-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-amazon-redshift-working-session/
Azure Synapse
https://coffingdw.com/azure-synapse-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/azure-synapse-analytics-row_number/
https://coffingdw.com/azure-synapse-analytics-cumulative-sum/
https://coffingdw.com/azure-synapse-analytics-moving-difference/
https://coffingdw.com/azure-synapse-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-azure-synapse-working-session/
SQL Server
https://coffingdw.com/sql-server-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/sql-server-analytics-row_number/
https://coffingdw.com/sql-server-analytics-cumulative-sum/
https://coffingdw.com/sql-server-analytics-moving-difference/
https://coffingdw.com/sql-server-analytics-cume_dist/
Yellowbrick
https://coffingdw.com/yellowbrick-analytics-part-2-ranking-data/
https://coffingdw.com/yellowbrick-analytics-row_number-2/
https://coffingdw.com/yellowbrick-analytics-cumulative-sum/
https://coffingdw.com/yellowbrick-analytics-moving-difference/
https://coffingdw.com/yellowbrick-analytics-cume_dist-2/
https://coffingdw.com/the-lead-analytic-function-on-yellowbrick-working-session/
Vertica
https://coffingdw.com/vertica-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/vertica-analytics-row_number/
https://coffingdw.com/vertica-analytics-cumulative-sum/
https://coffingdw.com/vertica-analytics-moving-difference/
https://coffingdw.com/vertica-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-vertica-working-session/
DB2
https://coffingdw.com/ibm-db2-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/ibm-db2-analytics-row_number/
https://coffingdw.com/db2-analytics-cumulative-sum/
https://coffingdw.com/ibm-db2-analytics-moving-difference/
https://coffingdw.com/ibm-db2-analytics-cume_dist/
Oracle
https://coffingdw.com/oracle-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/oracle-analytics-row_number/
https://coffingdw.com/oracle-analytics-cumulative-sum/
https://coffingdw.com/oracle-analytics-moving-difference/
https://coffingdw.com/oracle-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-oracle-working-session/
Teradata
https://coffingdw.com/teradata-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/teradata-analytics-row_number/
https://coffingdw.com/teradata-analytics-cumulative-sum/
https://coffingdw.com/teradata-analytics-moving-difference/
https://coffingdw.com/teradata-analytics-cume_dist/
Greenplum
phttps://coffingdw.com/greenplum-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/greenplum-analytics-row_number/
https://coffingdw.com/greenplum-analytics-cumulative-sum/
https://coffingdw.com/greenplum-analytics-moving-difference/
https://coffingdw.com/greenplum-analytics-cume_dist/
Netezza
https://coffingdw.com/netezza-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/netezza-analytics-row_number/
https://coffingdw.com/netezza-analytics-cumulative-sum/
https://coffingdw.com/netezza-analytics-moving-difference/
https://coffingdw.com/netezza-analytics-cume_dist/
Postgres
https://coffingdw.com/postgres-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/postgres-analytics-row_number/
https://coffingdw.com/postgres-analytics-cumulative-sum/
https://coffingdw.com/postgres-analytics-moving-difference/
https://coffingdw.com/postgres-analytics-cume_dist/
https://coffingdw.com/the-lead-analytic-function-on-postgres-working-session/
MySQL
https://coffingdw.com/mysql-analytics-rank-dense_rank-and-percent_rank/
https://coffingdw.com/mysql-analytics-row_number/
https://coffingdw.com/mysql-analytics-cumulative-sum/
https://coffingdw.com/mysql-analytics-moving-difference/
https://coffingdw.com/mysql-analytics-cume_dist/