How to use "distinct on"?

Yii 2.0 General Discussions
1

Hi,

how can I use "distinct on", with the QueryBuilder?

Thanks,

Urkman

2

just call the distinct() method


$query = new Query;

$query->distinct(true)

    ->select('id, name')

    ->from('user')

    ->limit(10);
3

Hi,

thanks for your answer, but "distinct on" is different to a simple distinct.

See here:

Greetings,

Urkman

4

you should add this as a text:




Model::find()->select('distinct on (a) *')
1 Like
5

thanks, you save my day !