Beginner's SQL: Duplicates Support

As a member of various database discussion forums over the last few years, I've seen thousands of SQL problems, many of which seem to show up again and again. Based on how frequently it is asked, the question of deleting duplicates is among the most common.

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

$2.89
- OR -

Rudy Limeback

Rudy LimebackRudy 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.

See All Postings From Rudy Limeback >>