with t as
(
select * , row_number() over (partition by empid order by empid) as rank from emp
)
delete from t where rank>1
Showing posts with label Delete Duplicate Data through single select query.. Show all posts
Showing posts with label Delete Duplicate Data through single select query.. Show all posts
Thursday, June 10, 2010
Subscribe to:
Posts (Atom)