Sean Lange (6/13/2013)

---

SQL_beginner1 (6/13/2013)

---

Hi Lynn,

I get the following error when I parse your script:

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'over'.

I'm using SQL Server 2008 R2.

He missed the () after ROW_NUMBER. Make sure you understand this code before you use it. 🙂

with DelDups as (

select

AccountCode,

StartDate,

EndDate,

rn = row_number() over (partition by AccountCode order by StartDate desc)

from

t_account_code

)

delete from DelDups

where rn > 1;