Query to filter duplicate rows from a table for duplication in 2 or more columns

There are scenarios when one has to find out duplicate records in a table for a combination of 2 or more columns. The query basically filters out the duplicate rows from a table evaluating the duplicacy on the basis of two or more columns (otherwise DISTINCT used for one column)

901 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook