SQL: How to count distinct rows?

[Armitage]

So I can count the rows: SELECT count(*) FROM my_table
I can return distinct rows: SELECT DISTINCT my_column FROM my_table

But can I count the distinct records without actually returning them?

 

[Mr.IncrediblyBored]

This would be one way. Perhaps not the best way, but still: