Postgres ROW_NUMBER Analytic
Migrate to Postgres, use advanced analytics, and save money. This blog teaches you how to use the ROW_NUMBER ordered analytic to find specific rows. Have you ever needed to find specific rows in a table, such as the first or last claim per family or the first two claims per individual? Use the ROW_NUMBER analytic and find the rows you desire.
Tom Coffing has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems. Amazingly, Nexus migrates between all the databases below with the click of the mouse.
• MySQL
• Excel
• Microsoft Access
• Snowflake
• Redshift
• Synapse
• BigQuery
• Teradata
• Oracle
• SQL Server
• DB2
• Hadoop
• MapR
• Greenplum
• Postgres
• Vertica
• Netezza
• SAP HANA
• Yellowbrick
• SQLite
Teaching your children about the data warehouse industry should be done as early as possible.
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 25 years. Tom has written over 75 books on all aspects of Teradata, Netezza, Yellowbrick, Snowflake, Redshift, Aurora, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 classes worldwide, and he is the designer of the Nexus Product Line.
