Level 104
Assuming your query was working as described above:
$db->query()->from($table)
->selectRaw('age, gender, count(some_number) as count')
->get();
May 11, 2018
2
Level 1
Need to use count in laravel query builder
Hello. I wanna to biuld db query, https://paste.laravel.io/15eebfc7-8e0b-4c49-a363-55f40c736729 and I need also to show count('some_number') .
Retrying here:
$db->query() ->from('mytable') ->where([['year', '>', 12]]) ->get(['age', 'gender', 'some_number']);
And I need to group by count(some_number), it should looks something like that
$db->query() ->from('mytable') ->where([['year', '>', 12]]) ->groupBy('some_number') ->get(['age', 'gender', count(some_number)]);
Anyone know how to do that?
Level 1
Try this :
$lines = \DB::table('mytable')
->select(\DB::raw("age, gender, count(*) as count"))
->where('year', '>', 12)
->groupBy('some_number')
->get();
Please or to participate in this conversation.