SELECT DISTINCT company, last_name, first_name FROM Sales; You can still use DISTINCT when narrowing and sorting your results, as with any SELECT statement.