Keep one id and remove the duplicate id

Question

suppose i have table student contain only single column ID And it value for ID is ID 1 1 2 3 2 4 4 So now i want to delete duplicate row and display out put is ID 1 2 3 4 So how i write query. Please help me Thanks in advance

Vipan Sharma · Answer

Try This. Its will work for you . I have tested WITH TempStudent (IdduplicateRecCount) AS ( SELECT IdROW_NUMBER() OVER(PARTITION by Id ORDER BY Id) AS duplicateRecCount FROM dbo.student ) --Now Delete Duplicate Records DELETE FROM TempStudent WHERE duplicateRecCount > 1 select * from student

Vipan Sharma · Answer

you welcome . Happy coding !!!

RAHUL PATIL · Answer

Thaxs vipan

Rajeev Punhani · Answer

Hi Rahul Please try WITH TempStudent (IDduplicateRecCount) AS ( SELECT IDROW_NUMBER() OVER(PARTITION by ID ORDER BY ID) AS duplicateRecCount FROM dbo.Student ) DELETE FROM TempStudent WHERE duplicateRecCount > 1 If the above solution is helpful then accept the answer.