SQL distinct for 2 fields in a database

Question

Can you get the distinct combination of 2 different fields in a database table? if so, can you provide the SQL example.

Answer 1

How about simply:

select distinct c1, c2 from t

or

select c1, c2, count(*)
from t
group by c1, c2

Answer 2

If you want distinct values from only two fields, plus return other fields with them, then the other fields must have some kind of aggregation on them (sum, min, max, etc.), and the two columns you want distinct must appear in the group by clause. Otherwise, it's just as Decker says.