How to use distinct in Zend Framework 2?

Question

How can I use the distinct clause with Zend\Db\Sql\?

Answer 1

I found this very usefull solution on http://blog.abmeier.de/php/zf2-select-distinct

$sql = new Sql($adapter);
$select = $sql->select();
$select->quantifier('DISTINCT');