由Laravel求和 [英] OrderBy Sum in Laravel

问题描述

我要如何在Laravel中订购一笔款项

How would I go about ordering a sum in Laravel

当前使用

Auth :: user()-> activities()-> groupBy('attempts_id')-> sum('points');

只给我第一行.我需要按降序排序并获取第一项.

Will only give me the first row. I need to order by that sum in descending order and grab the first item.

最后使用-> get()会导致错误:在非对象上调用成员函数get()

Using ->get() at the end results in an error: Call to a member function get() on a non-object

推荐答案

尝试一下:

Auth::user()
    ->activities()
    ->groupBy('attempts_id')
    ->orderByRaw('SUM(points) DESC')
    ->first();

这篇关于由Laravel求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！