Laravel 8 Min Price

Question

我有超过一种MIN的价格，我可以得到最低的价格。

dd($minPriceDealer=ScrapingPrices::where('product_id',$mobile->pro_id)->min('price'));

这只显示最低价格..。如何获取所有行数据

dd($minPriceDealer=ScrapingPrices::where('product_id',$mobile->pro_id)->min('price')->select(['price','id']));

错误:在int

上调用成员函数select()

Answer 1

我找到了解决办法

$minPriceDealer=ScrapingPrices::where('product_id',$mobile->pro_id)
        ->select('id','title','price', DB::raw('MIN(price) as cheapest_price'))
        ->groupBy('id')
        ->first();