请问 Laravel 里 MongoDB 多字段分组查询,如何查出每个组里某个字段的最大值?DB::raw ('MAX (totalMileage) as max_totalMileage') 不起作用
$result = DB::connection('mongodb')
->collection('tbox')
->select('vin', 'updateDataDate',"totalMileage",DB::connection('mongodb')->collection('tbox')->raw('MAX(totalMileage) as max_totalMileage'))
//->groupBy('vin')
->where("updateDataTime",">=","2020-06-28 00:00:00")
//->where("vin","=",'LVM6A1G10JF068481')
->groupBy("vin", "updateDataDate")
->get();
DB::raw(‘MAX(totalMileage) as max_totalMileage’)不起作用,得到的结果是:
推荐文章: