Get unique value from table Laravel

Question

I want to get all rows that have one unique column. The problem with my code is that it works only when I select just that one column, but in the end I need to have multiple columns.

$values= Model::select('id','value_first','gender_first','value_second','gender_second')->groupBy('value_first')->get();

$values= Model::select('id','value_first','gender_first','value_second','gender_second')->distinct('value_first')->get(); — Naeem Ijaz, Feb 21 '20 at 11:40
Welcome i'm posting My Answer You just vote for it to appriciate :) — Naeem Ijaz, Feb 21 '20 at 12:02

score 2 · Accepted Answer · answered Feb 21 '20 at 12:03

2

Here is Solution of Your Problem

$values= Model::select('id','value_first','gender_first','value_second','gender_second')->distinct('value_first')->get();

answered Feb 21 '20 at 12:03

Naeem Ijaz

805
9
17

score 1 · Answer 2 · answered Feb 21 '20 at 11:58

As per Laravel Documentation you can use distinct method for the same

The distinct method allows you to force the query to return distinct results for e.g

$values= Model::select('id','value_first','gender_first','value_second','gender_second')->distinct('value_first')->get();

Reference: Laravel-> Database: Query Builder -> Selects

Get unique value from table Laravel

2 Answers2