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 , ...
