CGI interview question

SQL Queries: i.e. how would you aggregate to get unique values in a table?