Laravel - Select Count with no field data repeated

Question

I am using Laravel-5.8 Eloquent to run a query. I want to get the total trucks utilized by a particular client for all their trips without counting a truck twice. I used the query below, but there is repetition of trucks used more than once:

  $truckcount = Trip::where('client_id', $userClientId)
   ->select(\DB::raw("COUNT(truck_no) as count"))
   ->distinct()   
   ->get();

How do I write the correct Eloquent query to achieve this?

[See this answer for eloquent without raw sql.](https://stackoverflow.com/a/35868746/3585500) — ourmandave, Oct 03 '19 at 11:29

score 1 · Accepted Answer · answered Oct 03 '19 at 11:09

1

try this:

 $truckcount = Trip::where('client_id', $userClientId)
   ->select(\DB::raw("COUNT(DISTINCT truck_no) as count"))
   ->get();

answered Oct 03 '19 at 11:09

Milad Barazandeh

321
2
9

Laravel - Select Count with no field data repeated

1 Answers1