Salesforce equivalent of “SELECT DISTINCT”?

Question

I want to know what all the existing values of a field are.

In SQL that would be something like:

SELECT DISTINCT foo

FROM bar

How might I do this with salesforce's SOQL?

Answer 1

Use Group by:

SELECT foo

FROM bar

GROUP BY foo