Domanda di colloquio di CGI

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