How to find duplicate rows with SQL

This article shows how to find duplicated rows in a database table. This is a very common beginner question. The basic technique is straightforward. I’ll also show some variations, such as how to find “duplicates in two columns”

http://www.xaprb.com/blog/2006/10/09/how-to-find-duplicate-rows-with-sql/