Thread: duplicate records in sql

I am Database Administrator (DBA)r. My projects include number of table. In which I need to find out any duplication of rows which has same content. I will need to use in query to find out the duplicate records in the tables. If you are having any suggestions then reply me. It can helpful to me.

Refer following SQL queries to find out the duplicate records of the table:

Code:

1.	select * from tablename group by FieldName HAVING count(distinct FieldName > 0)
2.	Select distinct (FieldName ) from TableName.