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?](https://stackoverflow.com/questions/43776758/how-can-i-solve-incompatible-with-sql-mode-only-full-group-by-in-laravel-eloquen) — miken32, May 06 '22 at 20:11

score 1 · Accepted Answer · answered May 06 '22 at 20:18

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();

Laravel - multiple select query

1 Answers1