Very often we have to look for duplicate records in the database, Below is the query which can give you the result.
SELECT COL1, COL2 , ...., Count(COLx) from TABLE_NAME GROUP BY COL1, COL2 , .... HAVING CONDITION AND Count(COLx)>1
SELECT COL1, COL2 , ...., Count(COLx) from TABLE_NAME GROUP BY COL1, COL2 , .... HAVING CONDITION AND Count(COLx)>1
I blog frequently and I seriously appreciate your information.
ReplyDeleteThis article has truly peaked my interest. I'm going to bookmark your site and
keep checking for new details about once a week. I subscribed to
your RSS feed too.
my website - financial help