• tomcoffing

Azure Synapse ROW_NUMBER Analytic




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. See the video below to make you an expert on ROW_NUMBER.









Here is the video of 15-tables joining across 15 database systems in a single query. Warning: This video contains what many experts thought was impossible.




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









The picture above shows Nexus migrating SQL Server to Azure Synapse in dark mode. Some customers migrate thousands of tables to the Azure Cloud, including Synapse, in a single job.


Watch the perfect parents teaching their child about data at an early age!








8 views0 comments