Here's one I've used to remove duplicate values in multiple rows in test:

begin tran

;with educ_dupes

as (

select BegDate,StudentID,EndDate,GPA,IsGraduate,Level,

EfeLocation,EfeMajor,EfeNumberOfYears,EfeRank,EfeSchool,

row_number() OVER (

PARTITION BY BegDate,EEID,EndDate,GPA,IsGraduate,Level,Location,Major,NumberOfYears,Rank,School

ORDER BY studentID) as dupe

from Educ)

delete educ_dupes

where dupe =2

Here's one I've used to remove duplicate values in multiple rows in test:

begin tran

;with educ_dupes

as (

select BegDate,StudentID,EndDate,GPA,IsGraduate,Level,

EfeLocation,EfeMajor,EfeNumberOfYears,EfeRank,EfeSchool,

row_number() OVER (

PARTITION BY BegDate,EEID,EndDate,GPA,IsGraduate,Level,Location,Major,NumberOfYears,Rank,School

ORDER BY studentID) as dupe

from Educ)

delete educ_dupes

where dupe =2