Friday, December 24, 2021

Delete duplicate row in sql server

1. Delete duplicate row in sql server with CTC

With CTE as  
(  
Select Id,names,row_number() over (partition by id order by id) as rno from ##abc
)  
Select * from CTE order by id,names

With CTE as  
(  
Select Id,names,row_number() over (partition by id order by id) as rno from ##abc
)  
delete from CTE where rno>1

 



No comments:

Post a Comment

Linq Expression syntax for where condtion in linq

(Expression<Func<T, bool>> filter)