Remove duplicate records from a table in SQL Server

Remove duplicate records from a table in SQL Server

write a query to get the duplicate records from a table:



SELECT * FROM student_attendance_details WHERE Attendance_Id NOT IN (SELECT MIN(Attendance_Id) _
FROM student_attendance_details GROUP BY prn_no, atten_from_date, batch_id, subject_id,division_id)

this query return all duplicate records.

Now we can delete all duplicate entries of records from table, for that i wrote a
query:

DELETE FROM student_attendance_details WHERE Attendance_Id NOT IN (SELECT MIN(Attendance_Id) _
FROM student_attendance_details GROUP BY prn_no, atten_from_date, batch_id, subject_id,division_id)


So, our table contains unique records, all duplicates are removed from table......