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

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

Ever find yourself with multiple/duplicated rows in your SQL Server table? This video tutorial will show you the quickest way to get rid of those "imposter" rows by introducing you to the first couple of steps in the process.

Highlights:

• How to identify the duplicate values
• What does the RANK function basically do?
• Where/when to use the RANK function
  

---

• Source: http://www.LearnTransactSQL.com
• Category: Design Patterns for Transact-SQL
• Skill Level: 500 (Advanced)
• Length: 08:00 (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: duplicate,rows,values,RANK, function,