SQL statements commonly used by SQL Server to retrieve Repeated Records

1. Obtains the data of a field or several fields that have repeated entries.
   Select field1, field2 from Table group by field1, field2 having count (field1)> 1
2. Obtain the latest records with no repeated Fields
   Select top * from Table A where ID in (select max (ID) from Table B group by field) order by ID DESC
3. Obtains the number of duplicates of a field.
   Select count (field) from Table group by field having count (field)> 1
4. Retrieve records that are not repeated
   Select field1, field2 from Table group by field1, field2
5. Delete duplicate records
   Delete from Table A where id not in (select max (ID) from Table B group by field)