select * from student
if record is like that
2.
After that write this query:
select ROW_NUMBER() over(partition by name order by name) R, name, dob from
student
R is Row number
3.
Finally
write query for deleting the duplicate row and execute this query.
delete q from(select ROW_NUMBER() over(partition by name order by name) R,
name, dob from student)q where R>1
4.
After the deletion the command table will look like this.
Join the conversation! Your thoughts help the community grow.