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

Convert 1.25x speed spent hours convert into normal (1x) speed spent hours

If I run a video with 1.25x or 125% speed till 1 hour 26 minuts, then normal hours will be ?   1 hours 26 minuts convert into hours Total 60...