New Transact SQL Video Tutorial: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details

This video will continue to show you the process of deleting duplicate rows using the RANK function in a SQL server table

Highlights:

• Using common table expressions
• Ranking and partitioning within a result set

---

• Source: http://www.LearnTransactSQL.com
• Category: Design Patterns for Transact-SQL
• Skill Level: 500 (Advanced)
• Length: 07:45 (9MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: delete, duplicate, RANK, function, table expressions, ranking, partitioning