Beginner's SQL: Duplicates Support
In this article, we'll look at the nature of the duplicates problem, how it arises, and then examine several approaches to resolving the issues.
During the course of the tutorial we'll also see how to write queries that address such other common situations, such as how to select the supplier with the lowest price for a product (from several offering the same item).
Rudy Limeback
Rudy Limeback is an independent consultant with over 20 years of SQL experience using DB2, SQL Server, Access, Oracle, and MySQL. Rudy is also a Web developer, Technical Editor at Digital Web, one of the original evolt.org admins, with his own Web site since 1996. More information at r937.com. Rudy lives in Toronto, Canada, where the weather allows you to play frisbee golf all year long.