Friday, November 27, 2009

SQL Server Video Tutorial - Pt 2 - How to Delete Duplicate Rows i n a SQL Server Table Using the Rank() Function

SQL Server  training video

MSSQL Programming and Query Writing Screencast: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

A SQL Server training video from the LearnItFirst the web's largest IT Training Video Library

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

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

SQL Server Programming and Queries video tutorial

N.B.: This training video comes from LearnItFirst's SQL Server Programming (SQL Server 2005/2000): Transact SQL video course.