First page Back Continue Last page Image

Getting Rid of Duplicates in Your Select Statement

Let’s say I want to know how many Different Sponsors Have Space Travel Firsts

This would be a reasonable first step, Just ask for the Sponsors in the table

But we really do not want to know how many times a Sponsor is on the list for this Query, So How do we eliminate the duplicates?

We use the DISTINCT Keyword