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)

 
 
 
 
 
(0)
854 times
Add to favorites
Databases
3/27/2013
E-mail Twitter del.icio.us Digg Facebook