Skip to content

Instantly share code, notes, and snippets.

@aramkoukia

aramkoukia/deduplicatin-data-tsql.sql

Created March 2, 2017 19:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save aramkoukia/1468c930696ed4199697edeb5b7d1ccb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save aramkoukia/1468c930696ed4199697edeb5b7d1ccb to your computer and use it in GitHub Desktop.
Download ZIP
TSQL Deduplicating data
Raw
deduplicatin-data-tsql.sql
;WITH myCTE (RowNumber, ProductId, ProductName)
AS (
SELECT ROW_NUMBER() OVER (
PARTITION BY ProductName ORDER BY ProductName
) AS RowNumber ,
ProductId ,ProductName FROM #Products
)
SELECT * FROM myCTE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment