Group by database query in laravel not working

Question

I am new to Laravel.

I have a database table named A and column names are 1,2,3 .

In column 3 i have different values like a,b,c. Now what i want is to print out the total no of values of a,b and c using group by clause. Sorry for my bad English. Thanks in advance.

i am doing it like

$cot=DB::table('A')->group By('3')->count();

    echo $cot;

Matt Stephens · Accepted Answer · 2016-07-27 09:13:21Z

1

There seems to be a space in the query.

It should look like the below.

$cot = DB::table('A')->groupBy('3')->count();

echo $cot;

edited Jul 27, 2016 at 9:13

answered Jul 26, 2016 at 10:38

Matt Stephens

9101 gold badge7 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Group by database query in laravel not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related