Listing 2: GROUP BY clause with no aggregate function 
SELECT Salesperson, SalesRank 
FROM Sales 
GROUP BY Salesperson, SalesRank