I want to know what all the existing values of a field are.
In SQL that would be something like:
SELECT DISTINCT fooFROM bar
SELECT DISTINCT foo
FROM bar
How might I do this with salesforce's SOQL?
Use Group by:
SELECT fooFROM barGROUP BY foo
SELECT foo
GROUP BY foo
To learn in-depth about Workflow in Salesforce, sign up for an industry based Salesforce Admin certification.