Listing 1: DISTINCT clause 
SELECT DISTINCT Salesperson, SalesRank 
FROM Sales