Level 51
YourModel::where('carId', $carId)->count();
1 like
Feb 7, 2023
4
Level 1
Eloquent question: Is there a way to perform count query for column with the same id?
I'm trying to find a way to execute this query: SELECT carId, COUNT(1) FROM event_dataGROUP BYcarId ORDER BY COUNT(1) DESC but with Models, i didn't find anything in docs so i came here
Level 1
@MohamedTammam i need a list of rows, not only one row
@sinnbeck is this the only way to achieve that?
Level 102
@szalikdev What do you mean? Using a model?
EventData::query()
->selectRaw('carId, COUNT(1)')
->groupBy('carId')
->orderByRaw('COUNT(1)', 'desc')
->get()
Level 102
DB::table('event_data')
->selectRaw('carId, COUNT(1)')
->groupBy('carId')
->orderByRaw('COUNT(1)', 'desc')
->get()
1 like
Please or to participate in this conversation.