Laravel - multiple select query

Question

I want to pull data from two columns in my database table, I'm not very good at querying SQL. When I do this query I get this error:

Expression #2 of SELECT list is not in GROUP BY clause and contains...

What am I missing?

My query:

$top_orders = OrderItem::select('name','productId', DB::raw('count(name) as total'))->groupBy('name')->orderBy('total','desc')->take(5)->get();

Does this answer your question? How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent? — miken32
– miken32, Commented May 6, 2022 at 20:11

xuma · Accepted Answer · 2022-05-06 20:18:36Z

1

It is SQL Standard feature and its not anything to do with laravel. You can add required column to group by or use an aggragete function like sum etc.

If you specify the GROUP BY clause, columns referenced must be all the columns in the SELECT clause that do not contain an aggregate function. These columns can either be the column, an expression, or the ordinal number in the column list.

$top_orders = OrderItem::select('name','productId', DB::raw('count(name) as total'))
  ->groupBy('name','productId')
  ->orderBy('total','desc')
  ->take(5)
  ->get();

answered May 6, 2022 at 20:18

xuma

4944 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Laravel - multiple select query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related