I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many ways to pinpoint specific rows in a dataset, such as the first or last sale per product or the highest or lowest grade point. Get ready to add to your analytic arsenal.

My goal is to write a blog for every analytic across every database. I have written 15 Row_Number Analytic blogs for the 15 databases you see below. Find the database you are interested in and click the link. You will see brilliant examples of how to use Row_Number that have been tested on that specific database.

Snowflake: https://coffingdw.com/snowflake-analytics-row_number/

Databricks: https://coffingdw.com/databricks-analytics-row_number/

Redshift: https://coffingdw.com/amazon-redshift-analytics-row_number/

BigQuery: https://coffingdw.com/google-bigquery-analytics-row_number/

Synapse: https://coffingdw.com/azure-synapse-analytics-row_number/

Yellowbrick: https://coffingdw.com/yellowbrick-analytics-row_number-2/

Vertica: https://coffingdw.com/vertica-analytics-row_number/

Teradata: https://coffingdw.com/teradata-analytics-row_number/

Oracle: https://coffingdw.com/oracle-analytics-row_number/

SQL Server: https://coffingdw.com/sql-server-analytics-row_number/

DB2: https://coffingdw.com/ibm-db2-analytics-row_number/

Netezza: https://coffingdw.com/netezza-analytics-row_number/

Greenplum: https://coffingdw.com/greenplum-analytics-row_number/

Postgres: https://coffingdw.com/postgres-analytics-row_number/

MySQL: https://coffingdw.com/mysql-analytics-row_number/

Posted in Blog