How to select unique values ​​from database in yii2?

Question

Yii

It is necessary to select values ​​for 2 fields (For example, code and name), lines where the "code" field is repeated, although the "name" field is different, should not be selected.
The result should look something like this:
Array [
[code => 1, name => a],
[code => 2, name => a],
[code => 3, name => b],
]

Answer 1

Something like that
$query->groupBy('code');

Answer 2

Try:

Model::find()->select(['code', 'name'], 'DISTINCT')->all();