Laravel Group By and Order By not working

Question

I tried to make a Laravel 5.8 project, and the data in the project is like this :

id  |purch| name         |  prcvalue
------------------------------------
1   |10234| Nabila       | 100
2   |10234| Nadeera      | 450
3   |10234| Nabila       | 540
4   |10234| Nadeera      | 480

then i need to show that data like this :

id  |purch| name         |  prcvalue
------------------------------------
3   |10234| Nabila       | 540
4   |10234| Nadeera      | 480

I have tried using GroupBy = name and OrderBy prcvalue DESC but it just return :

id  |purch| name         |  prcvalue
------------------------------------
1   |10234| Nabila       | 100
2   |10234| Nadeera      | 450

does anyone know how i can get the results that i need? here my code :

myModel::where('purch','=','10234')
      ->orderBy('prcvalue','DESC')
      ->groupBy('name')
      ->get();

many thanks

Does this answer your question? [Order By before Group By using Eloquent (Laravel)](https://stackoverflow.com/questions/31857961/order-by-before-group-by-using-eloquent-laravel) — Yasin Patel, Nov 18 '19 at 07:15

Mdr Kuchhadiya · Answer 1 · 2021-03-04T04:57:53.570

3

If You want the latest id of records then you can use unique() after get(), don't use group by if you use groupBy then you lose your control from id. I hope this is useful for you

myModel::select('id','purch','name','prcvalue')
  ->where('purch','=','10234')
  ->orderBy('prcvalue','DESC')
  ->get()
  ->unique('name');

edited Mar 04 '21 at 04:57

answered Mar 04 '21 at 04:51

Mdr Kuchhadiya

431
4
12

score 2 · Accepted Answer · answered Nov 18 '19 at 07:37

2

I think you need max value ,

  myModel::select('id','purch','name',DB::raw("MAX(prcvalue) as prcvalue"))
  ->where('purch','=','10234')
  ->orderBy('prcvalue','DESC')
  ->groupBy('name')
  ->get();

And if it still not working , edit in config/database.php. In mysql array , set to strict => false

answered Nov 18 '19 at 07:37

Zar Ni Ko Ko

352
2
7

well this works, i get highest prcvalue, but the id that showing is not the id of the higest prcvalue, the id must be "3" not "1" , many thanks – muflih karim Nov 18 '19 at 07:50
I just give you another advice , firstly you should select out max value of prcvalue and then you get data by where in max prcvalue . In this way , you perhet no need group by. – Zar Ni Ko Ko Nov 18 '19 at 08:01
Or how about groupBy('id') – Zar Ni Ko Ko Nov 18 '19 at 08:04

Laravel Group By and Order By not working

2 Answers2

Linked