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

Raw Insert query in EF8 or Entity Framwork 8

          public async Task<object> InsertRack(Rack RackInsert)         {             try             {                 sql = " i...