How to use distinct in Zend Framework 2?

Question

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

https://github.com/zendframework/zf2/blob/master/library/Zend/Db/Sql/Expression.php — Sam, Mar 11 '13 at 20:43

Mihai · Answer 1 · 2013-06-24T16:08:19.263

35

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');

edited Jun 24 '13 at 16:08

answered Jun 24 '13 at 15:05

Mihai

366
3
5

This is the proper answer and should be marked as answer – bksi Jun 24 '18 at 18:40

score 19 · Accepted Answer · answered Mar 12 '13 at 16:16

19

Use an expression in your column selection.

$select = new Select('tablename');
$select->columns(array(new Expression('DISTINCT(id) as id')));

answered Mar 12 '13 at 16:16

Andrew

12,617
1
34
48

7

also $select->columns(array('id' => new Expression('DISTINCT(id)'))); Key will become alias – Greg Apr 18 '13 at 13:56
This is a hack, and wrong. "distinct" is a property of the row, not of the column. Once you want more than one column, this will not work at all. – bart Jul 13 '21 at 07:34

score 19 · Answer 3 · answered Sep 29 '13 at 20:33

19

While Mihai Dobre's answer is correct, I think you should use the constants provided by the framework instead of using a string literal. This will make your code more future-proof.

$sql->select()->quantifier(\Zend\Db\Sql\Select::QUANTIFIER_DISTINCT)

answered Sep 29 '13 at 20:33

Julian

8,808
8
51
90

score 0 · Answer 4 · answered Oct 15 '18 at 11:34

0

This worked best for me.

$select = $this->select()
          ->distinct()
          ->where('user_id = ?', $user_id);

http://webphplearn.com/blog/blogdetail/Distinct_in_Zendframework2

answered Oct 15 '18 at 11:34

Tristan Hudson

151
1
12

How to use distinct in Zend Framework 2?

4 Answers4