Tag Archives: partition

Use CTE and Table Partition and Ranking Functions to Delete Rows with Duplicates

This post demonstrates to use T-SQL table partition, row_number ranking function, together with CTE to delete duplicated data from a table. The logic is saved in a stored procedure for reuse purpose. Two Tables in the Example: Orders table uses … Continue reading

Posted in Database | Tagged , , , , , | Leave a comment