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

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

This final video on how to delete duplicate rows in a SQL server table via use of the RANK ( ) function will show you an alternative placement of the ranking function.

Highlights:

• Where can I put the RANK function and where will it accurately work?
• Reason for JOIN of actual table to duplicates
  

---

• Source: http://www.LearnTransactSQL.com
• Category: Design Patterns for Transact-SQL
• Skill Level: 500 (Advanced)
• Length: 11:45 (13.5MB)
• 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: