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