Salesforce Developer Community

Hi All,

I am trying to do a SELECT DISTINCT values from one of our custom tables. The equivalent of

SELECT DISTINCT fieldA,fieldB from tableC

But it looks like there is no way to do this with the Salesforce API am I correct ? if yes then how can I run a query like this ?

Later on I will need to run a query to get the count of distinct values in a table,
I can do SELECT count() FROM tableA

but cant do SELECT DISTINCT count() FROM tableA

Thanks